Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nawazuddin234
New Contributor III

Syntax of joining

Hi All,

I want to left join 2 tables on 3 fields in Qliksesne , can anyone let me know what should be the syntax i need to follow ,

TIA

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Syntax of joining

May be something like this by creating composite key like this in both the tables -

Autonumber(Field1&Field2&Field3,'Counter') as KeyField,

You will need to delete Field1,Field2 and Field3 from one of the table so that joining is done with the help of KeyField.

Also be aware that in load statement we need to use source filed names, the calculated fields after 'as' keyword are not available in the same load statement.

2 Replies
nawazuddin234
New Contributor III

Re: Syntax of joining

digvijay‌ Can you please help

Digvijay_Singh
Honored Contributor III

Re: Syntax of joining

May be something like this by creating composite key like this in both the tables -

Autonumber(Field1&Field2&Field3,'Counter') as KeyField,

You will need to delete Field1,Field2 and Field3 from one of the table so that joining is done with the help of KeyField.

Also be aware that in load statement we need to use source filed names, the calculated fields after 'as' keyword are not available in the same load statement.

Community Browser