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 Number700000000403791G09K9G0001HK7880000||RACK: ELECTRONICS70130000042401615486846ALARIS 8015||PUMP: PCU70130000042393215487065ALARIS 8015||PUMP: PCU702150000SG-48261 EXADATA X7-2||COMPUTER: FILE SERVER702150000428077PA20L30KHB9PX3000RTN||UNINTERUPTED POWER SUPPLY7021500004203037826F8X8408-44E||COMPUTER: FILE SERVER702500000424524US43359776INTELLIVUE INFO CENTER IX||PATIENT MONITORING EQUIPMENT70345000042362715382492ALARIS 8015||PUMP: PCU705401000423802CAB2118490585CE8140||STORAGE SYSTEM: CRYOGENIC705700000SG-53148 REVERIE 8058-80||SOFA706102000400741F01047VITA||PATIENT MONITORING EQUIPMENT706260000408926120916762S3||BED: ELECTRIC HOSPITAL707400000410267PPM-15382HEARTMATE POWER BASE UNIT||VENTRICULAR ASSIST DEVICE707400000418279T6J08405DXVALLEYLAB FT10 ENERGY||ELECTROSURGICAL GENERATOR707400000417186DJH017469P5392||PACEMAKER: CARDIAC EXTERNAL70930000041555214288279ALARIS 8100||PUMP: PC70930000041393614306664ALARIS 8100||PUMP: PC70930000041658314457365ALARIS 8300 ETCO2||PUMP: INFUSION70931300041613615080110VASC PRO||TABLE: ULTRASOUND709700000410546SDJ13491135SACOROMETRICS 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!

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

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!

Custom Tools

Interface Tools

Accepted answers

apathetichell

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...

revised listbox selector 7 19 2021.yxwz

All comments

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.

listbox selector 7 19 2021.yxwz

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.

revised listbox selector 7 19 2021.yxwz

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.

apathetichell

revised listbox selector 7 19 2021.yxwz

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703