topic Re: How to split values that appear in one row? in Getting Data In

How to split values that appear in one row?

ikoniasavina — Tue, 12 May 2020 12:07:52 GMT

I have search querrie created from json file. Problem is values that i have appear in one row, instead of 3 rows(in json file we have three ids with number and status). Thanks in advance!!
alt text

Re: How to split values that appear in one row?

to4kawa — Tue, 12 May 2020 12:36:50 GMT

use mvzip to three fields. and mvexpand and re-extract them.

Re: How to split values that appear in one row?

vnravikumar — Tue, 12 May 2020 12:39:53 GMT

Try this

| makeresults 
| eval id="02,03,01" 
| makemv delim="," id 
| appendcols 
    [| makeresults 
    | eval Number="30,20,40" 
    | makemv delim="," Number] 
| appendcols 
    [| makeresults 
    | eval Status="In progress,In Progress,To Do" 
    | makemv delim="," Status] 
| fields - _time 
| eval temp=mvzip(mvzip(id,Number),Status) 
| fields temp 
| mvexpand temp 
| eval temp_value=split(temp,",") 
| eval id=mvindex(temp_value,0), Number=mvindex(temp_value,1), Status=mvindex(temp_value,2) 
| table id Number Status

Re: How to split values that appear in one row?

ikoniasavina — Tue, 12 May 2020 13:05:46 GMT

Thanks. This looks great! But it should be done without given values.

Re: How to split values that appear in one row?

ikoniasavina — Tue, 12 May 2020 13:06:33 GMT

Can you show me on example querry

Re: How to split values that appear in one row?

to4kawa — Tue, 12 May 2020 13:09:40 GMT

what's your query?

Re: How to split values that appear in one row?

ikoniasavina — Wed, 30 Sep 2020 05:21:37 GMT

Re: How to split values that appear in one row?

vnravikumar — Tue, 12 May 2020 13:21:49 GMT

Try this

source="jsonfile" 
| rename customfield_1 AS id, customfield_2 AS Status, customfield_3 AS Number 
| eval data=mvzip(mvzip(id,Number),Status) 
| mvexpand data 
| makemv data delim="," 
| eval id=mvindex(data,0),Number=mvindex(data,1), Status=mvindex(data,2) 
| fields - data

Re: How to split values that appear in one row?

ikoniasavina — Tue, 12 May 2020 13:29:52 GMT

This is great!!They are separated now with their values. Is it possible to make a table only from those three: id, number and label. because a result returns also other fields. could you help me with that?

Re: How to split values that appear in one row?

vnravikumar — Tue, 12 May 2020 13:42:18 GMT

You can use table command with the required column at the end

Re: How to split values that appear in one row?

ikoniasavina — Tue, 12 May 2020 13:48:21 GMT

Great! Thank You very much!

Re: How to split values that appear in one row?

vnravikumar — Tue, 12 May 2020 13:52:38 GMT

Please accept the answer.