Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

what are the possible ways in qlik sense server to join two table ?

hi

what are the possible ways in Qlik sense server to join two table ?

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Find below couple of helpful links.

Understanding Join and Concatenate | Qlikview Cookbook

Join ‒ Qlik Sense

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
mato32188
Specialist
Specialist

Hi Nupur,

could you please give more insight into your issue?

Thanks.

BR

Martin

ECG line chart is the most important visualization in your life.
YoussefBelloum
Champion
Champion

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 ?

Anonymous
Not applicable
Author

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 ?

Anonymous
Not applicable
Author

I just want to know how to join tables in qlik on mutiple columns.?

Anonymous
Not applicable
Author

hi,

I want to know how to join 2 tables in Qlik sense on the basis of multiple columns.

mato32188
Specialist
Specialist

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

ECG line chart is the most important visualization in your life.
martinpohl
Partner - Master
Partner - Master

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

Anonymous
Not applicable
Author

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?