Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.