Left Join

[Anonymous]

Hi,

I would like to create a left join between two tables: ChecklistTasks and JoinCountryNew.

The connection field is COUNTRY in the two tables.

Please help me to identify what I do wrong and how to write the code correctly:

[vLookup]:

Left Join ([ChecklistTasks])

LOAD

    COUNTRY,

    Country_Cluster,

    Region

FROM [lib://AttachedFiles/JoinCountryNew.xlsx]

(ooxml, embedded labels, table is Sheet1);

[petter]

You will have to explain what is not working for you... Do you get an error message or does the join simply not join in any additional fields or what? In addition what are the fields in the table CheckListTasks?

[Anonymous]

No error, just the join doesn't work.

In the table ChecklistTasks there are many fields, one of them is COUNTRY and this is the field I would like to connect with the JoinCountryNew table.

[petter · Accepted solution]

Have you checked that there are any match between the values in the COUNTRY field between the two tables?

[Anonymous]

Capital letters! That was the different between the COUNTRY fields.

Thank you

[petter]

Please mark the question as answered and correct to close the thread

[manoj217]

nice Answer Petter we will check in code level you have answered in data level.