Try something like this | makeresults format=csv data="A,B,C,D,E,F
0.1,b1,0.1,d1,0.1,f1
0.11,b2,0.2,d2,0.35,f2
0.2,b3,0.3,d3,0.9,f3
0.22,b4,,,1.0,f4
0.4,b5
0.5,b6
0.55,b7
0.9,b8"
| table A B C D E F...
See more...
Try something like this | makeresults format=csv data="A,B,C,D,E,F
0.1,b1,0.1,d1,0.1,f1
0.11,b2,0.2,d2,0.35,f2
0.2,b3,0.3,d3,0.9,f3
0.22,b4,,,1.0,f4
0.4,b5
0.5,b6
0.55,b7
0.9,b8"
| table A B C D E F
``` The lines above create dummy event data in line with your example (it is often helpful if you had provided this yourself) ```
| appendpipe
[| rename A as a
| rename B as b
| eval C=null()
| eval D=null()
| eval E=null()
| eval F=null()]
| fields - A B
| appendpipe
[| where isnotnull(C)
| eval A=null()
| eval B=null()
| eval a=C
| rename C as c
| rename D as d
| eval E=null()
| eval F=null()]
| fields - C D
| appendpipe
[| where isnotnull(E)
| eval A=null()
| eval B=null()
| eval C=null()
| eval D=null()
| eval a=E
| rename E as e
| rename F as f]
| fields - E F
| where isnotnull(a)
| stats values(*) as * by a
| rename a as A
| rename b as B
| rename c as C
| rename d as D
| rename e as E
| rename f as F