Discussion board where members can get started with Qlik Sense.
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 ,
Go to Solution.
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.
digvijay Can you please help