Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guptanupur
New Contributor II

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

Re: 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

Join ‒ Qlik Sense

Regards,

Kaushik Solanki

mato32188
Contributor III

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

Hi Nupur,

could you please give more insight into your issue?

Thanks.

BR

Martin

YoussefBelloum
Esteemed Contributor

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

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 ?

guptanupur
New Contributor II

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

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 ?

guptanupur
New Contributor II

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

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

guptanupur
New Contributor II

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

hi,

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

mato32188
Contributor III

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

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

martinpohl
Valued Contributor II

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

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

guptanupur
New Contributor II

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

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?