topic Re: Find the different fields between two tables in QlikView

Find the different fields between two tables

Mon, 29 Jul 2013 07:33:08 GMT

Good morning and good Monday everyone!

I need to find the differences (the different fields) between two tables.
For example:

Table A:

A1 Bzw998

A2 Cdw955

A3 Yxp900

A5 Djj244

A7 Mnw104

A8 Vbc456

A9 Rtk777

Table B:

A1 Bzw998

A2 Cdw955

A4 Ghk888

A5 Djj244

A6 Ell777

A7 Mnw104

A8 Vbc456

Table result:

A3 Yxp900

A4 Ghk888

A6 Ell777

A9 Rtk777

How can I do this?
Maybe with OUTER JOIN?

Thanks in advance!

Re: Find the different fields between two tables

Mon, 29 Jul 2013 07:57:24 GMT

also run this code

TableA:

load * inline [

id, name

A1, Bzw998

A2, Cdw955

A3, Yxp900

A5, Djj244

A7, Mnw104

A8, Vbc456

A9, Rtk777

];

join

TableB:

load * inline [

id, name

A1, Bzw998

A2, Cdw955

A4, Ghk888

A5, Djj244

A6, Ell777

A7, Mnw104

A8, Vbc456

];

Result:

load id as newid, name as newname

resident TableA

where match(id,'A3','A9','A4','A6');

drop table TableA;

then output like this

newid	newname
A3	Yxp900
A4	Ghk888
A6	Ell777
A9	Rtk777

Re: Find the different fields between two tables

Mon, 29 Jul 2013 08:10:03 GMT

Thanks vishwaranjan.

But I'm finding a generic solution.

The tables mentioned are examples, but the fields are not fix.

I will use the script to find the differences between a txt result of reading each bar code from clothes from our provider and compare the fields with our reading.

Thanks.

Re: Find the different fields between two tables

kaushiknsolanki — Mon, 29 Jul 2013 08:12:17 GMT

Hi,

Try below code.

This will clear your idea.

Inclusion:
Load id as Temp_ID FROM a;

Inner Join
Load id as Temp_ID FROM b;

Exclusion:
Load id,name FROM A Where not exists(Temp_ID,id);

Concatenate
Load id,name FROM B Where not exists(Temp_ID,id);

Drop table Inclusion;

Regards,

Kaushik Solanki

Re: Find the different fields between two tables

Mon, 29 Jul 2013 08:47:44 GMT

Thank you very much Kaushik!

It works

Re: Find the different fields between two tables

Marcio_Campestrini — Wed, 25 Jun 2014 14:11:49 GMT

Thanks Kaushik. I was facing this problem until I've found your post.