remove negative match to account

[bsbernabe]

Hello There,

How to get the match two field account no. from two diffs. tables and remove all negative?

Data Source:

Account No. A	Account No. B	Account No. Should be
123	123	123
456	456	456
789	789	789
-	901
-	112
-	113

Best Regards,

Bing

[Arthur_Fong · Accepted solution]

Try:

inner join(TableA)

load *

resident TableB;

drop table TableB;

[Saravanan_Desingh]

tab1:
LOAD * INLINE [
    F1
    123
    456
    789
];

tab2:
LOAD * INLINE [
    F1
    123
    456
    789
    901
    112
    113
]
Where Exists(F1);