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!

[dougperez]

You will need to create a chained app to do that...
See this link: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

[apathetichell]

What do you mean by re-select as needed? Do you mean run the app multiple times and select different ids? Try the attached and see if it's what you want.

[krworthington]

It looks like this is probably going to work. However, in my actual data, the Department Number is actually a V_String in this format- 123456789:Department Name and I need to keep it in this format. Sorry, I should have formatted it like this in my example. How would I modify the App accordingly? I haven't been able to get it to work with the V_String field. Thanks!

[apathetichell]

Do you need the dropdown to show 123456789:Department Name or just Department Name or just 123456789? can you mock up a few more examples? It should be a fairly fast fix...

[krworthington]

So here is what it really looks like.

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

[apathetichell]

And to confirm - you want the entire first column as the dropdown?

Your filter needs to change to reflect how the spaces and : are going to be reformatted via the crosstab tool - to do this the filter is changed to say:

REGEX_Replace([Department Number],"([!\W]+)","_") in ("test")

The other minor change is that the multi-field tool which changed field type is no longer needed since you are now comparing strings to strings... See attached.

[krworthington]

Yes. The entire first column should be the drop-down. Should I be changing ("test") to a value in my data set? I am getting the drop-down and can select values, but no records are returned, And I know my selection has associated records. The Revised example is working fine, it's just when I substitute my own data set that I encounter this.

[apathetichell]

Run the workflow first - and then can you confirm that in dropdown your selections look like the values you are filtering for - but any commas and : are changed to _....? "test" stays "test" - that's the stand in for what the list is going to replace....

Can you drag a formula tool onto the canvas before the filter and throw REGEX_Replace([Department Number],"([!\W]+)","_")  on it? see if the result exactly matches the value you see in the dropdown... if not the conversion could be off a bit.

[krworthington]

The drop-down selections look correct.

I copied the Regex Replace formula into a Formula Tool, output to a new column, and all values are 0 (zero). Output to [Department Name] returns all values 0.