Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

How do I create a dropdown or select tool style filter with multiple selectable values?

krworthington
6 - Meteoroid

I want to create a filter where I can select multiple Department Numbers and returning all of the records with those Department Numbers. So for example, if I select Department Numbers 701300000 and 702150000, I want to get a total of 5 records with all of the related columns. I want to be able to re-select different Department Numbers as needed.

Data example below:

 

Department NumberProduct IDSerial NumberModel Number
700000000403791G09K9G0001HK7880000||RACK: ELECTRONICS
70130000042401615486846ALARIS 8015||PUMP: PCU
70130000042393215487065ALARIS 8015||PUMP: PCU
702150000SG-48261 EXADATA X7-2||COMPUTER: FILE SERVER
702150000428077PA20L30KHB9PX3000RTN||UNINTERUPTED POWER SUPPLY
7021500004203037826F8X8408-44E||COMPUTER: FILE SERVER
702500000424524US43359776INTELLIVUE INFO CENTER IX||PATIENT MONITORING EQUIPMENT
70345000042362715382492ALARIS 8015||PUMP: PCU
705401000423802CAB2118490585CE8140||STORAGE SYSTEM: CRYOGENIC
705700000SG-53148 REVERIE 8058-80||SOFA
706102000400741F01047VITA||PATIENT MONITORING EQUIPMENT
706260000408926120916762S3||BED: ELECTRIC HOSPITAL
707400000410267PPM-15382HEARTMATE POWER BASE UNIT||VENTRICULAR ASSIST DEVICE
707400000418279T6J08405DXVALLEYLAB FT10 ENERGY||ELECTROSURGICAL GENERATOR
707400000417186DJH017469P5392||PACEMAKER: CARDIAC EXTERNAL
70930000041555214288279ALARIS 8100||PUMP: PC
70930000041393614306664ALARIS 8100||PUMP: PC
70930000041658314457365ALARIS 8300 ETCO2||PUMP: INFUSION
70931300041613615080110VASC PRO||TABLE: ULTRASOUND
709700000410546SDJ13491135SACOROMETRICS 259CX||PATIENT MONITORING EQUIPMENT: FETAL


I've looked at some Community threads regarding the Drop Down and List Box Interface tools, but I'm not sure if that's the right direction or not.

 

Thanks in advance!

13 REPLIES 13
apathetichell
15 - Aurora

One more - this one creates a dummy field (testvalue) which is then matched... Try using this with your actual data. It may help to cut and past the first entry into the filter tool and again into the action tool to replace: "700000000_Department_Name" exactly - including the quotes...

 

If you do that and you run it you should get a join on at least one value.... you may need to change the field you are comparing to testvalue as well  - and if it works you can drop it in the join section... 

 

 

 

krworthington
6 - Meteoroid

This appears to have worked! Thank you so much for all of your help! 

krworthington
6 - Meteoroid

dougperez --I couldn't get chained apps to work for my use case, but this did point me in the right direction and I can see this being useful for some other things I'll need to do in the future. Thanks for taking the time to reply!

apathetichell
15 - Aurora

Glad to hear!

Labels