I am searching for a field TRANSACTION_DATE, how to I get just that field and not include ones like TRANSACTION_DATE_NUM?
I apologize if this has been asked before, I can’t seem to find answer that relates. Thank you!
The column filter uses a “contains” comparison and I can how how that creates an issue for you.
To filter a specific field, right click the field and select “Filter to selected”.
You can combine both the column filter and the right-click filter. For example, enter “TRANSACTION” in the column filter to narrow the list and then right-click “TRANSACTION_DATE”.
In this specific use case, you can also use a column filter of “%TRANSACTION_DATE”. The “%” is an “EndsWith” operator so in this case would match only the string you wanted.
I find the right-click method more intuitive and accurate.
-Rob