Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Have you checked that there are any match between the values in the COUNTRY field between the two tables?
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?
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.
Have you checked that there are any match between the values in the COUNTRY field between the two tables?
Capital letters! That was the different between the COUNTRY fields.
Thank you
Please mark the question as answered and correct to close the thread
nice Answer Petter we will check in code level you have answered in data level.