That won't work as expected. If File is "XYZ_*" then Consumer will be set to "" because of the last eval statement. For instances like this, use the case function. base search
| rex field User...
See more...
That won't work as expected. If File is "XYZ_*" then Consumer will be set to "" because of the last eval statement. For instances like this, use the case function. base search
| rex field User | rex field Folder | rex field File
| eval Consumer = case(match(File, "^xyz"), "Core",
match(File,"^ABC"),"Core",
match(File,"^MNP"),"Non-Core",
1==1,"Others")
| table File Consumer