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 :)

Labels