Exclude values

[Sir_Than]

I have a table called Temp with many columns, and a column called ID. In the load statement of this table, there is a ''where not match'' clause that excludes many values from the field ID.

I also have an excel file with only a column called ID.

I want to keep the Temp table and replace the ''where not match'' clause with a snippet of code that will exclude the values that are the same in the excel file and in the Temp table.

Can you help me on this?

[BrunPierre]

Hi, one solution could be as below.

ExcludingIDs:
LOAD ID

FROM [Excel File];

Temp:
LOAD ID,
<Other fields>

FROM <Table>.db
Where not Exists(ID);

DROP Table ExcludingIDs;

EXIT SCRIPT;

[MarcoWedel]

Load ID as ExcludeID from your Excel and restrict your Temp table load with "Where not Exists(ExcludeID, ID)".