topic Re: Join not working despite keys are the same in Talend Studio

Join not working despite keys are the same

HJlassi1619437866 — Mon, 28 Nov 2022 09:15:33 GMT

Hello everyone,

Hope you're doing fine,

i'm trying to do a join with tmap for two different sources of data, despite keys values is the same, the join is not working

Source A :

Id Name Date Categorie Ref

001000fa88ri Harry 2019 News 147303360

Source B :

ID Type Statut Gendre Date Ref

10006389_001 IDM ACTIF null 2019 147303360

I'm using ref as key for my join,

I kept on getting null value from source B, i tried to trim the input value but still the same problem, any body have an idea?

Thank you in advance.

Anonymous — Tue, 29 Nov 2022 04:56:47 GMT

Hello,

We see that you are using "Unique Match" for Match Model. Do other Match models make this join work?

Best regards

Sabrina

HJlassi1619437866 — Tue, 29 Nov 2022 08:28:08 GMT

Unfortunately no, i've tried all type of match but still no chance.

corentin1 — Wed, 30 Nov 2022 14:24:06 GMT

You've trimmed data from your main flow. Did you also trim data from your lookup query ?