Why input from lookup become null in the output after a joined it

[Mayman1611554379]

After i joined the variable "country" on the tmap, the output still become null, i tried inner join, left join, unique match and first match, none of them work. the output only fetch input from main table only

and the output will become like

how can i fix this? thank you in advance

i put data in text for reference

[PaulyWally]

I would be interested in also seeing the data from the tMap input. But here are a few things I noticed:

1. You are using a LEFT JOIN. That is OK but remember than any unmatched records will be NULL on the output. So make sure a LEFT JOIN is what you really want.
2. Talend JOINS are case-sensitive. If the Country data is not consistent in both recordsets, it will not JOIN. i.e. - "Afghanistan" <> "afghanistan". Make sure your casing matches in both recordsets. If the casing is irrelevant, make both sides upper case before the JOIN.
3. The lookup data you provided contains trailing spaces in all of the Country column data. i.e. - "Afghanistan" <> "Afghanistan ". Check the data on the tMap input to see if there are trailing spaces in that as well. If the trailing spaces are irrelevant, TRIM both sides before the JOIN.