Hi,
I am using Infinity UQL datasource for Visualization.
I have a variable named “Label”, which has 2 data (Value1 and Value2).
I need to pull the columns based on the condition selected in Variable.
For example,
|parse-csv
| where ‘${Label}’==‘Value1’ |project “Column1”
| where ‘${Label}’==‘Value2’ |project “Column2”
This works only with 1 where statement but not with 2.
What is correct way to do this?
Best Regards,
Rithesh