Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

itamarchubb
New Contributor III

Left Join

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);

1 Solution

Accepted Solutions
MVP
MVP

Re: Left Join

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

6 Replies
MVP
MVP

Re: Left Join

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?

itamarchubb
New Contributor III

Re: Left Join

No error, just the join doesn't work.

Capture.PNG

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.

MVP
MVP

Re: Left Join

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

itamarchubb
New Contributor III

Re: Left Join

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

Thank you

MVP
MVP

Re: Left Join

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

manoj217
Contributor II

Re: Left Join

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

Community Browser