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