Identify type of joining

[Anonymous]

Colleagues, good day!

Simple question:

Script loads first table:

Id	Field1
1	A
2	A
3	A
4	A
5	A
6	A

Then i must load second table but only data for those Id which are not contain in first table:

Second:

Id	Field2
1	B
2	B
3	B
4	B
8	B
9	B

In result i must get only:

Id	Field2
8	B
9	B

Thanks.

[Anonymous]

Thanks, dear.

[sunny_talwar]

Why is 5 included, but 1 or 2 not included in your final output?

[Anonymous]

Sorry, it's my mistake:

Necessary result:

Id	F1
1	3
2	ed
3	fd
4	dfd
5	fdf
7	u

[sunny_talwar]

May be like this:

A:

LOAD Id,

          Field1,

          Id&Field1 as Check

FROM....

B:

NoConcatenate

LOAD Id,

          Field1

FROM ...

Where not Exists(Check, Id&Field1);

DROP Table A;

[Anonymous]

Perfect!

Thanks!