Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
I solved this using a loop and condition block and replicated your list by adding the rows manually to a Variable.
The full solution looks like that:
For the loop, I choose the second column as inputs:
Or just input it as JSON (you will have to adapt the table name according to your input): {$.TestTable[*][1]}
The condition is an if clause, if the current item in loop equals "xxx":
For the output, use the current loop index as input for the row (first bracket [{$.loop.index}]) and output the value in the first column (second bracket: [0])
Running the application, I get the requested output:
Hope that helps
Philip
I solved this using a loop and condition block and replicated your list by adding the rows manually to a Variable.
The full solution looks like that:
For the loop, I choose the second column as inputs:
Or just input it as JSON (you will have to adapt the table name according to your input): {$.TestTable[*][1]}
The condition is an if clause, if the current item in loop equals "xxx":
For the output, use the current loop index as input for the row (first bracket [{$.loop.index}]) and output the value in the first column (second bracket: [0])
Running the application, I get the requested output:
Hope that helps
Philip
Hi @poojask123 ,
i have created a straight table in Qlik app by creating table of your data using Inline script.In automaton i have used that straight table data to filter out your output recipient emails.
You could just use the Filter List Block to get this List, so no need for extra condition in a loop.
