Hi, i will like to extract the count for the following
Data_no: 1T
Identity: A
Data_no: 2T
Identity: C
i tried the following
| rex max_match= 0 "(?m) Data_no: (?<DataNo>[a-zA-Z0-9#]+)"
| rex max_match= 0 "(?m) Identity: (?<Identity>[a-zA-Z0-9#]+)"
| stats count(eval(Identity= "A")) as A, count(eval(Identity= "C")) as C by DataNo
The table returns the following:
DataNO| A | C
1T | 1 | 1
2T | 1 | 1
How to i filter it so that it will become like this:
DataNO| A | C
1T | 1 | 0
2T | 0 | 1
Thanks for your help!
... View more