How to exclude data available from other table

[#1]

I was trying to load a table using SQL join , but its seems this is not supported.

is there any other way to do it during the load

Table1                                 Table2

Date|Name|X|S                  Date|Z

I would like to load all data in table1 but to exclude the matched records in table2.

How can I achieve this?

[Anonymous]

[Table1]:

Load Date, Name, X, S

from [YourTable1];

concatenate(Table1)

Load Date, Z

from [YourTable2]

where not exists(Date);

[Anonymous]

Try this:

[#4 · Accepted solution]

Thank you Marcio.

This was not right solution.

I managed to solve this by using resident and where not exists.

[Anonymous]

ok