How to figure out if it matches between two table

[#1]

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,

[#2]

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