Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
what are the possible ways in Qlik sense server to join two table ?
Find below couple of helpful links.
Understanding Join and Concatenate | Qlikview Cookbook
Regards,
Kaushik Solanki
Hi Nupur,
could you please give more insight into your issue?
Thanks.
BR
Martin
Hi,
you can do it on qliksense Desktop but you don't know how to upload your app to the server ? or you can't upload apps on the server ? or you just want to know how to join tables on Qlik ?
How can I join two tables on basis of two or more columns? With the help of association it's possible to do so only with one column .Can u suggest either by using qlik join or in load script ?
I just want to know how to join tables in qlik on mutiple columns.?
hi,
I want to know how to join 2 tables in Qlik sense on the basis of multiple columns.
HI Nupur,
FirstTable:
Load Column1,
Column2,
Column3
FROM xxx1;
left/right/outer/inner join (FirstTable)
Load Column1,
Column2
FROM xxx2;
Is it what you need?
Thanks
BR
Martin
if you are using the join load statement the tables you want to join are joined by all fields who are in both tables
be sure that you want to join the tables. the significate dissicult between Qlik and other BI Tools is that you don't need a big table or cube. the link between tables (also by fields with the same name) is automatically.
if you need to link by more than one field (legal Entity, ordernumber and year for axample) you have to built a concat field (e.g. legal Entity & ordernumber & year as key) in both tables and only in one table the single fields for select.
understand and live the easyness of Qlik!
regards
hi Martin ,
"if you need to link by more than one field (legal Entity, ordernumber and year for axample) you have to built a concat field (e.g. legal Entity & ordernumber & year as key) in both tables and only in one table the single fields for select."
Can u explain me more on the bold and underlined part in the above quoted lines?