Alteryx Designer Desktop Discussions

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

Multiple data filter based on contains

alt_tush
9 - Comet

Hi,

 

I have created a APP where in list box below are the values.

 

06240
06247
06815
06816
06817
09009
09001

 

Based on above multiple selections from list box i want to filter the data from below dataset.

 

 

Name
AD_06240_Monthly
AD_06247_20230201_02550000_Monthly
AD_ATL_06815_Monthly
AD_ATL_Test_06816_Monthly
AD_ATL_06817_Monthly
AD_ATL_RIQ_ABM09009
AD_ATL_RIS_ABM09001_20230405_02550000

 

 

If user checked 06815 & 09009 then alteryx give me only two entries from above dataset i.e.

 

AD_ATL_06815_Monthly
AD_ATL_RIQ_ABM09009

 

Same way based on list box selection my data should  be fileter.

 

Note : My list box number is always five digit.

 

Appreciate your help :)

 

Thank you,

 

4 REPLIES 4
gautiergodard
13 - Pulsar

Hey @alt_tush 

Here is one way to get to your solution:

gautiergodard_0-1682791601393.png

Attaching workflow for your reference.

 

Hope this helps!

 

Yoshiro_Fujimori
15 - Aurora

Hi @alt_tush ,

 

Another solution, using Dynamic Replace tool.

 

Workflow

Yoshiro_Fujimori_0-1682810083731.png

 

APP image

Yoshiro_Fujimori_2-1682810195847.png

 

Output image

Yoshiro_Fujimori_3-1682810213595.png

 

I hope this helps.

ahsanaali
11 - Bolide
 
 

Attach pls find a proposed solution.

alt_tush
9 - Comet

All three solutions works.. Thank you for your reponse :)

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels