Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table listing all the fields for my transactions, including the purchase order number (Field = [Purchase Order]).
I want a button that will cause this table to show only the transactions where there is no purchase order number.
What search string do I use? I have searched discussion and manuals and cannot find it -or don't understand what I do find 🙂
THANK YOU!
Create a flag in the script
Trxn:
LOAD [Obj Acct],
[Subsi- diary],
[Account Description],
[G/L Date],
Month,
Amount,
[Purchase Order],
If(Len(Trim([Purchase Order])) = 0, 1, 0) as NullFlag
FROM
[sample_trxn.xlsx]
(ooxml, embedded labels, table is Sheet1);
and then use it like this
May be this
Concat(DISTINCT {<Transactions = {"=Len(Trim([Purchase Order])) = 0"}>} Transactions, '|')
based on Sunnys approach,use select in field:
='("'&Concat(DISTINCT {<Transactions = {"=Len(Trim([Purchase Order])) = 0"}>} Transactions, '"|"')&'")'
Yes forgot to add those things
I saw those types of strings but thought...it couldn't be that complicated!
Thanks...trying it now.
='("'&Concat(DISTINCT{<Trxn={"=Len(Trim([Purchase Order]))=0"}>}Trxn,'"|"')&'")'
it does not work. It gives me an error after the first <
Trxn is the name of the table (not Transactions)
What are you trying to select here? I mean what field?
then Trxn isn't a valid field
Trxn is the loaded table - not the Table Object. the Table object is TB04.
Which field are you looking to make selection in using the button?