Find Not Matching rows in two tables in Script

[#1]

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

[MK_QSL]

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;

[#3]

Thanks Manish for your quick response.

[#4]

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';