How to "loop" or repeat a search with all values of a field to generate a table?

[SrishtiPalani]

Hello,

How to "loop" or repeat a search with all values of a field to generate a table and count the values? I have tried foreach and map, but I believe I'm not using the syntax correctly. Thank you!

[gcusello · Accepted solution]

Hi SrishtiPalani,
try something like this:

| inputlookup tiers.csv 
| makemv tiers
| rex field=tiers "\d\=(?<single_tiers>[^ ]*)"
| nomv tiers
| stats values(tiers) AS tiers by single_tiers

Bye.
Giuseppe

[niketn]

@SrishtiPalani, how many distinct APPs you have in total? How will you get the distinct APP names(is it from the same lookup file)?