Using List Box with a Connected Tool

ANarag

I read several questions on this topic but I am unable to make my workflow work.

Attached is simplified version of my workflow but basically I need the ability to multi-select from a list of values to filter my output. 

I connected my list box to an input data with ID and Agent Bank Name Legal Name.  In the list box, what I wanted was to be able to select from the list of values in my Agent Bank Legal Name column, but instead, my list box is asking me to choose Agent Bank Legal Name and/or ID.  Then depending on what the user chooses, I placed an Action Tool to update a Filter Tool to I can output only the data the matches the Agent Bank Legal Name.

Would appreciate help on how I can connect all these tools together to create the output needed.

FYI: In workflow, I am using an excel file for both my input data but I really need to connect to an oracle database, so I am hoping the solution can also work for a table.

In case the data is not showing up, here's sample:

Some sample Input Data for the List Box:

Agent Bank Legal Name	ID
"Swedbank" AB	1
"Swedbank" AS	2
ANZ Bank New Zealand Ltd.	131
AO Citibank	3
Banco BCT S.A.	8
Banco Bilbao Vizcaya Argentaria SA	9
Banco de Chile	13
Banco Itaú Uruguay S.A.	10
Banco Nacional de Mexico, S.A. (Banamex)	11
Banco S3 CACEIS Mexico, S.A., Institucion De Banca Multiple	12
Bank Handlowy w Warszawie SA	14
Bank Hapoalim BM	15
Bank of China Limited	17
Bank of Taiwan	18
Bank Polska Kasa Opieki SA	16
BNP Paribas S.A.	4

Here's the some sample Input Data that I need to filter on:

Agent Bank Market	Agent Bank Legal Name	Agent Bank Short Name	Agent Bank Domicile	Agent Bank Regulator	Contracting Party Name	Contracting Party Domicile	Contracting Party Regulator
Russia	AO Citibank	Citi Russia	Russia	Central Bank of Russia (CBR)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC) Federal Reserve Board (FRB) Office of the Comptroller of the Currency (OCC)
Costa Rica	Banco BCT S.A.	BCT Costa Rica	Costa Rica	National Supervisory Counsel of the Financial System (Consejo Nacional de Supervisiondel Sistema Financiero, CONASSIF)	Corporacion BCT SA	Costa Rica	National Supervisory Counsel of the Financial System (Consejo Nacional de Supervisiondel Sistema Financiero, CONASSIF)
Spain	Banco Bilbao Vizcaya Argentaria SA	BBVA Spain	Spain	Bank of Spain (Banco de Espana, BoS), National Securities Market Commission (Comisión Nacional del Mercado de Valores. CNMV)	Banco Bilbao Vizcaya Argentaria SA	Spain	Bank of Spain (Banco de Espana, BoS) National Securities Market Commission (Comisión Nacional del Mercado de Valores. CNMV)
Chile	Banco de Chile	Banco de Chile for Citi	Chile	Financial Market Commission (Comision para el Mercado Financiero, CMF)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC) Federal Reserve Board (FRB) Office of the Comptroller of the Currency (OCC)
Uruguay	Banco Itaú Uruguay S.A.	Itau Uruguay	Uruguay	Central Bank of Uruguay (Banco Central de Uruguay, BCU)	Banco Itaú Uruguay S.A.	Uruguay	Brazilian Central Bank (Banco Central do Brasil, BCB) Brazilian Securities Commission (Comissao de Valores Mobiliarios, CVM) Central Bank of Uruguay (Banco Central de Uruguay, BCU)
Uruguay	Banco Itaú Uruguay S.A.	Itau Uruguay	Uruguay	Central Bank of Uruguay (Banco Central de Uruguay, BCU)	Itau Unibanco S.A.	Brazil	Brazilian Central Bank (Banco Central do Brasil, BCB) Brazilian Securities Commission (Comissao de Valores Mobiliarios, CVM) Central Bank of Uruguay (Banco Central de Uruguay, BCU)
Poland	Bank Handlowy w Warszawie SA	Citi Poland	Poland	Financial Supervision Authority (Komisja Nadzoru Finansowego, PFSA), General Inspector of Financial Information (GIFI), National Depository for Securities (NDS)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC) Federal Reserve Board (FRB) Office of the Comptroller of the Currency (OCC)
Israel	Bank Hapoalim BM	Bank Hapoalim Israel	Israel	Bank of Israel (BoI), Israel Securities Authority (ISA)	Bank Hapoalim BM	Israel	Bank of Israel (BoI) Israel Securities Authority (ISA)
China	Bank of China Limited	Bank of China	China	China Banking and Insurance Regulatory Commission (CBIRC), China Securities Regulatory Commission (CSRC), People's Bank of China (PBOC), State Administration of Foreign Exchange (SAFE)	Bank of China Limited	China	China Banking and Insurance Regulatory Commission (CBIRC) China Securities Regulatory Commission (CSRC) People's Bank of China (PBOC) State Administration of Foreign Exchange (SAFE)
Taiwan	Bank of Taiwan	Bank of Taiwan	Taiwan	Central Bank of the Republic of China (Taiwan) (CBC), Financial Supervisory Commission (FSC)	Bank of Taiwan	Taiwan	Central Bank of the Republic of China (Taiwan) (CBC) Financial Supervisory Commission (FSC)

ListBox_AgentBankName.yxmd

SPetrie

The connected tool is showing you the 'fields' which is why its only shows the name and id as options to choose.

You can adjust that to be an external file with name/value pairs but not sure what the best way to get your Oracle data into that would be.

I edited it to use an external excel file and also changed it to use single quotes instead of double quotes to start and stop items.

I also changes the filter formula to be 'in' so it can find multiple items and adjusted the select tool accordingly.

I also checked off the browse tool in the interface designer.

Even if it was successful, it would not have displayed the results without it.

Hope this helps

Updated workflow is attached

ListBox_AgentBankName.yxzp