Hello, in the below data I have a lot of processes and the ParentProcesses of them.
I would like to keep only the rows related with process "Process4" meaning the first 3 rows.
| makeresults
| eval mydata="Process1,Process2 Process2,Process3 Process3,Process4 Process5,Process6 Process6,Process7 Process8,Process9 Process7,Process10"
| makemv mydata
| mvexpand mydata
| makemv delim="," mydata
| eval ParentProcess=mvindex(mydata,0)
| eval Process=mvindex(mydata,1)
| table ParentProcess Process
Many thanks in advance.
... View more