Hi Alteryx
I have a dataset that contains name and value pari and i want to update those accordingly to one of my filter , how can i achieve this?
@187 Can you elaborate a little bit more on your requirement?
yup so the filter clause is dynamic which is read from the first dataset , the name will be the filter column and the value will be the filter value
supposed in this case the dataset is
name value
report group 1 A
report group 2 B
I need to have the filter like
[report group 1] = "A"
AND
[report group 2] = "B"
if more rows from first dataset ,i need it to be appended to the filter clause
@187 ,
Here is my solution to your problem :-).
i think you can also use the filter tool with some kind of macro construction to work (nice challenge haha) but this setup is more simple i guess.
If you expect more columns than just 2 to be filtered. just click dynamic or unknown columns in the transpose tool :-).
Greetings,
Seb