I have a set of data as below:
If you can see, the TagNames are repetitive. I would want to re-arrange it to below format
TagName LimitString1 LimitString2 LimitString3 .. . . . . . . . . .
CHEM_R13719 null 18
CHEM_R13720 null 01
.
.
CHEM_R13723 0 4940
May I know how can I use stats command to achieve this? Thank you
It seems you are looking for something like this:
index=.... | stats list(LimitString) as "Limit String" by TagName
Try...
Your search
| eval LimitString=coalesce(LimitString,"")
| stats count by TagName LimitString
Unfortunately, the output is not what I required. Basically, we need to sort the values in LimitString, into the respective TagName. I was reading up on the "bin" command, not sure it would help in getting what I wanted.