topic Re: Find Not Matching rows in two tables in Script in QlikView

Find Not Matching rows in two tables in Script

Sat, 28 Mar 2015 06:03:58 GMT

Hello All,

i want to find the not matching rows in two different tables with same field numbers and name.

for e.g:-

Table A:

Name Sale

Prince 100

Arun 200

Table B:

Name Sale

Prince 100

Arun 200

Suresh 300

So ans. should be suresh 300.

Please Help me on this..

Thanks & Regards

Prince Anand

Re: Find Not Matching rows in two tables in Script

MK_QSL — Sat, 28 Mar 2015 09:23:59 GMT

T1:

Load *, Name&Sale as Key1 Inline

[

Name, Sale

Prince, 100

Arun, 200

];

NoConcatenate

T2:

Load * Inline

[

Name, Sale

Prince, 100

Arun, 200

Suresh, 300

] Where Not Exists (Key1, Name&Sale);

Drop Table T1;

Re: Find Not Matching rows in two tables in Script

Sat, 28 Mar 2015 10:20:13 GMT

Thanks Manish for your quick response.

Re: Find Not Matching rows in two tables in Script

Sat, 28 Mar 2015 11:19:30 GMT

Hi,

you can try this.

Table:

LOAD * INLINE [

Name, Sale

Prince, 100

Arun, 200

]

Where Name <> 'Prince'and Name <> 'Arun';

add

LOAD * INLINE [

Name, Sale

Prince, 100

Arun, 200

Suresh, 300

]

Where Name <> 'Prince'and Name <> 'Arun';