topic Difference between two tables in QlikView

Difference between two tables

qlikviewalex — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Difference between two tables

ahaahaaha — Fri, 26 May 2017 10:43:57 GMT

Hi Alex,

As variant

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

];

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

Re: Difference between two tables

prma7799 — Fri, 26 May 2017 10:51:31 GMT

Please share your expected output.

Re: Difference between two tables

antoniotiman — Fri, 26 May 2017 11:45:20 GMT

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