We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create a filter like on Pivot Table

kauser
8 - Asteroid

How can i create a filter like on Pivot table from below data to select specific table. i use filter tool with AND but didn't work 

A=12, B=QQ, C=W1, D=USD, E=Y, F= OLD

 

ABCDEF
12QQW1USDYOLD
21QQW2USDYOLD
12ERW2USDYOLD
45REW2USDYOLD
12QQW1USDYOLD
12REW2USDYOLD
12QQW1EURYOLD
54ERW2USDNNEW

 

Thank you 

 

 

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

Not sure I understand - are you asking to just Filter data? If so, a filter tool will do the trick, and OR looks like what you may be needing instead of AND: A=12 OR B=QQ OR etc.

 

 

Labels
Top Solution Authors