Difference between two tables

[qlikviewalex]

Hi,

I want to load the fields of a table which are not contained in another.

Does anyone have an idea how I can implement this?

Alex

[ahaahaaha]

Hi Alex,

As variant

S:

LOAD*,

0 as Flag,

A&'|'&'|'&B&'|'&C as Key; //include fields that do not to be the same

LOAD*Inline              

[A, B, C              

7, 8, 9

4, 5, 6

];

R:

LOAD*,

If(Exists(Key, A&'|'&'|'&B&'|'&C)=-1, 0, 1) as Flag,

A&'|'&'|'&B&'|'&C as Key; //include fields that do not to be the same

LOAD*Inline

[A, B, C

1, 2, 3

4, 5, 6

];

NoConcatenate

R\S:

LOAD

A, B, C

Resident S

Where Flag = 1;

DROP Table S;

Result

Regards,

Andrey

[prma7799]

Please share your expected output.

[antoniotiman]

Hi,

may be this

R:
LOAD * Inline [
A,B,C
1,2,3
4,5,6
];
Join
Load *,1 as Flag Inline [
A,B,C
7,8,9
4,5,6
];
LOAD A,B,C Resident R Where Flag <> 1;
Drop Table R;

Regards,

Antonio