Need interface tool which to be used

Question

Hi All,

Can anyone help me to get the tool which to be used for below query. I have below data and want to select the data based on company code. IF i need only 8001 then data run for 8001 only so which interface tool will work. also, there need a option as well that don't select any company and run for all company. Please help me get the tool and configuration as well in tool.

Document TypeDocument NumberDocument Header TextReferencePosting DateCompanyTrading PartnerAmount in doc. curr.Document currencyZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20238001TP1001375USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20231001TP1001271.17USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20233310TP1001640USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20238001TP1001350USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20233310TP1001400USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20233310TP1001450USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20233310TP1001105USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20232410TP10011500USDZA54001330CSS USD AR Inv DEC 22CSSUSDARDEC2201/01/20232410TP10011000USD

Thanks,

FrederikE · Accepted Answer

Hey @Srawat,

Here is how I'd do it. The dropdown is populated via the Input Tool with the available Companies (Cross Tabed bc. they need to be in the header, cell value doesn't matter).

No Filter doesn't look the best, but it works.

Note that this doesn't work on Gallery since the autopopulate of the Dropdown doesn't do so. If it should work on Gallery you eather need a chained app or fixed values in the dropdown.