Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I use the following a lot when selecting data from the SQL server:
SQL SELECT
FROM "Item Ledger Entry"
Where "Global Dimension 2 Code" not in ('CF');
I would like to use this same function when loading from a "Table File" but it seems not to be working.
What is the solution for this?
hi
you can use not exists statement that only load values from a field if they aren't already exists in another field or the same field
May be like this
Where Not Match([Global Dimension 2 Code], 'CF');