where not exits function issue

[ravindraa]

Hi all,

  i struck one place give me some suggestion,

I have two tables one is Transaction table and other one is Rejection Table.

what are the Transaction's are matching with Rejection table Transaction's i am excluding those transaction's from Transaction table using where not Exits function.

but the thing is some transaction are repeating in other branches but those are not exclude.

please find the attached document . i created output sheet also.

kindly give any suggestion...

Thanks in advance................................... 

[ravindraa]

Hi Experts,

  kindly look into it, give me any suggestion how to do this.

Thanks in advance...........................

[tresesco · Accepted solution]

Try like:

Table1:

Load *,

  Scheme&Plan&Brach&folino as Key

  Inline [

Scheme,Plan,Brach,folino,Rbranch,Trno,Rtrno

CF,GP,HY01,123,HY01,1,2

TY,0TPlan,Delhi,108,Delhi,7,8

UB,0UPlan,Jaipur,109,Jaipur,9,10

];

Table2:

Load *

  Inline [

Scheme,Plan,Brach,td Trno,folino,Trtype,ihno,AMOUNT

CF,GP,HY01,1,123,RED,222,100

CF,GP,HY01,2,123,REDR,222,100

AB,OAPlan,Mumbai,3,101,P,333,200

CF,Ocplan,Mumbai,4,102,R,444,500

GH,0GPlan,Chennai,5,107,Red,555,600

GH,0GPlan,Chennai,6,107,P,666,10

TY,0TPlan,Delhi,7,108,Red,999,30

TY,0TPlan,Delhi,8,108,REDR,800,40

UB,0UPlan,Jaipur,9,109,RED,900,50

UB,Uplan,Jaipur,10,109,REDR,1000,60

GH,0GPlan,Chennai,1,110,P,666,111111

TY,0TPlan,Kochi,2,111,Red,999,222222

] Where Not Exists(Key,Scheme&Plan&Brach&folino );

Drop Table Table1;

[ravindraa]

Hi Tresesco,

  Thank you very very very much .....................................

it is working for me