Not in statement

[ranibosch]

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?

[lironbaram]

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 

not exists help

[sunny_talwar]

May be like this

Where Not Match([Global Dimension 2 Code], 'CF');

[vvira1316 · Accepted solution]

Try "Global Dimension 2 Code" <> ('CF')

If that doesn't work then providing a sample mock data file would be helpful to assist you