Join not working despite keys are the same

[HJlassi1619437866]

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]

Hello,

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

Best regards

Sabrina

[HJlassi1619437866]

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

[corentin1]

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