Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to figure out if it matches between two table

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,

1 Reply
Not applicable
Author

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