How to figure out if it matches between two table

Mon, 09 Dec 2013 19:25:17 GMT

Hello all,

I have this problem, I'm not quite sure even if it's possible.

I have two files

File A

---------

identifier A, identifier B, ID, others ...

File B

---------

identifier A, identifier B, IDC, others ...

Now I need to find out if ID == IDC and if it does then say it matched and else

So Table output should be

identifier A, identifier B, ID, IDC, ID==IDC,

Re: How to figure out if it matches between two table

Mon, 09 Dec 2013 20:57:59 GMT

I would try:

LEFT Join(TableA)

LOAD identifierA, identifierB, IDC, others .... From FileB;

LEFT Join(TableA)

LOAD identifierA, identifierB, ID, IDC

if(ID=IDC, 'MATCHED', 'NOT MATCHED')

Resident TableA

Fabrice