Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-02 05:01 PM

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

415 Views
0 Likes
1 Solution

Accepted Solutions
Digvijay_Singh
MVP
MVP
‎2018-04-02 07:04 PM

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.

View solution in original post

346 Views
2 Replies
Anonymous
Not applicable
‎2018-04-02 05:02 PM
Author

digvijay‌ Can you please help

346 Views
0 Likes
Digvijay_Singh
MVP
MVP
‎2018-04-02 07:04 PM

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.

347 Views