Use this inline script instead of expression and use CURRENCY_NAME as Dimension in list box
LOAD * INLINE [
It is suggested that maintain this in Excel or in database table to read instead of reading from INline table, it is easy to manage. If there is any change it is easy to change in Excel or database instead of changing code every time.
I try to enter the CURRENCY_NAME into excel file, i find that it able to display the same list box as your proposal.
But then now i have a lot of button which have Action on filed=SOURCE search string = TDSS , now my field = COMPANY_NAME label = TDSS will not turn on. may i know what should i do , so that i don't need to modify the button action expression ? ( Now when i use button action for field = COMPANY_NAME and search string = SG , it can turn on SOURCE= TDSS )
left(FileBaseName(), 4) AS TSD,
SOURC as SOURCE,
CURRENCY_NAME AS COMPANY_NAME
FROM $(vINPUTPath)$(vFile12).xls (biff, embedded labels, table is [SOURCE$]);
in my excel file i have below info :-
SOURC CURRENCY_NAME TDSS SG TDSID ID TDSPG PG TDSKL KL ADL AD TDST TH