About cfurstenau

cfurstenau · ‎02-12-2018

The original query might be my issue. I'm pulling it from an array of JSON objects that looks something like this: { "entry" : [ { "dataName" : "user", "dataValue" : "bob" }, { "dataName" : "ip", "dataValue" : "1.1.1.1" } ] } I used mvzip and mvexpand to get the first table, but that lost the "entry" grouping.

cfurstenau · ‎02-12-2018

I have a search that returns the following table: | Key | Value | |---------|---------| | user | bob | | ip | 1.1.1.1 | | traffic | 500 | | user | bill | | ip | 2.2.2.2 | | traffic | 200 | And I need it to look like this: | user | ip | traffic | |------|---------|---------| | bob | 1.1.1.1 | 500 | | bill | 2.2.2.2 | 200 |` I've tried using commands like transpose and xyseries without any luck.

Posts	2
Solutions	0
Karma Given	0
Karma Received	1
Member Since	‎02-12-2018

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

How can I combine multiple rows into 1 row?

Re: How can I combine multiple rows into 1 row?

How can I combine multiple rows into 1 row?

Join the Conversation

How can I combine multiple rows into 1 row?

Re: How can I combine multiple rows into 1 row?

How can I combine multiple rows into 1 row?