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

[krworthington]

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 Number	Product ID	Serial Number	Model Number
700000000	403791	G09K9G0001	HK7880000||RACK: ELECTRONICS
701300000	424016	15486846	ALARIS 8015||PUMP: PCU
701300000	423932	15487065	ALARIS 8015||PUMP: PCU
702150000	SG-48261		EXADATA X7-2||COMPUTER: FILE SERVER
702150000	428077	PA20L30KHB	9PX3000RTN||UNINTERUPTED POWER SUPPLY
702150000	420303	7826F8X	8408-44E||COMPUTER: FILE SERVER
702500000	424524	US43359776	INTELLIVUE INFO CENTER IX||PATIENT MONITORING EQUIPMENT
703450000	423627	15382492	ALARIS 8015||PUMP: PCU
705401000	423802	CAB2118490585	CE8140||STORAGE SYSTEM: CRYOGENIC
705700000	SG-53148		REVERIE 8058-80||SOFA
706102000	400741	F01047	VITA||PATIENT MONITORING EQUIPMENT
706260000	408926	120916762	S3||BED: ELECTRIC HOSPITAL
707400000	410267	PPM-15382	HEARTMATE POWER BASE UNIT||VENTRICULAR ASSIST DEVICE
707400000	418279	T6J08405DX	VALLEYLAB FT10 ENERGY||ELECTROSURGICAL GENERATOR
707400000	417186	DJH017469P	5392||PACEMAKER: CARDIAC EXTERNAL
709300000	415552	14288279	ALARIS 8100||PUMP: PC
709300000	413936	14306664	ALARIS 8100||PUMP: PC
709300000	416583	14457365	ALARIS 8300 ETCO2||PUMP: INFUSION
709313000	416136	15080110	VASC PRO||TABLE: ULTRASOUND
709700000	410546	SDJ13491135SA	COROMETRICS 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!

[apathetichell · Accepted solution]

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]

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

[krworthington]

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]

Glad to hear!