Splunk results identify

Help Studio
1

Hi All,

I have splunk results as above I want to show in message box for example TX had values other than zero populated message box should show VA has no traffic

Totally 3 values splunk results will show tx, va , az which one has values other than zero other has to show here in this screenshot tx, VA showing so VA has no values it should show

Seeking your expertise please

2

@Sathish_Ashokan

First get the data using extract dattable into a datatable

Then filter the column you need to remove 0 rows

Then use output datatable to convert datatable to string

Now use the string in message box to display

Cheers