i've got two table.
LOAD * INLINE [
YEAR, MONTH, VALUE, ID,
I want to create a new table that takes only the different values that are only present in table 1.
So a table with:
I tryed with outer join but it doesn't work.
This is the result, so it seems to be working just fine...?
View solution in original post
That doesn't look like an other join scenario at all... perhaps a Not Exists scenario?
Load ID from Table2;
Load * From Table1
Where Not Exists(ID);
Drop Table Table2;
thanks but this solution doesn't work.