hi,
i have data like below. i want to string into column values then need to join with my query.
System effected Region
a:b:c;d;e;f India
i need like below.
system effected Region
a India
b India
c India
d India
e India
f India
Thanks in advance
| makeresults | eval _raw="System effected_Region
a:b:c;d;e;f India" | multikv forceheader=1
`comment("Above just sets up test data")`
| eval System=split(System,":") | mvexpand System
| eval System=split(System,";") | mvexpand System
| makeresults | eval _raw="System effected_Region
a:b:c;d;e;f India" | multikv forceheader=1
`comment("Above just sets up test data")`
| eval System=split(System,":") | mvexpand System
| eval System=split(System,";") | mvexpand System