alteryx update filter clause base on a data set

[187]

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?

[binu_acs]

@187 Can you elaborate a little bit more on your requirement? 

[187]

@binu_acs 

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 

[Sebastiaandb]

@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