How to filter the data based on List Box Tool

[alt_tush]

Hi,

I have below set of data.I want to create the APP where i want to use the list box to filter the below data based on multiple selections of countries by user.

Name	Dept	Country
Mark	IT	HK
Brian	IT	HK
Alen	HR	HK
Tony	HR	SN
Lana	HR	SN
Heather	ADMIN	SN
John	IT	UK
David	HR	UK
Michael	ADMIN	US
Mathew	ADMIN	US
Jacob	ADMIN	US
Ross	FINANCE	HK
Joey	FINANCE	SN

I want to filter this records based on the selection criteria on List Box Tool

I have other Country file which define the coutries which i want to connect list box tool.

Country.xlsx file contains below unique countries detail

HK

SN

UK

US

If i select the HK & UK from List Box then only those records should process where country columns contain HK & UK from above dataset.

So i have multiple selection criteria.

Please let me know if you have any solution on this.

Thank you,

[binuacs · Accepted solution]

@alt_tush The below post might help your use case

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-update-a-list-box-and-filt...

[binuacs]

@alt_tush One way of doing this

[alt_tush]

HI binuacs,

Thank you for your respond. This solution works for me :)