Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
pooja821
Contributor

Combine content of two tables

How do we  use the content of two table in order to make the dashboard.

6 Replies
Partner
Partner

Re: Combine content of two tables

Hi Pooja,

All you have to do is use Qliks associative modelling to do this. Easiest way is to find a common field within both your sources, and ensure both the Linking field are the same name in both tables. This will create a link between the two tables, and then in the front end you can just add your dimension and measures.

pooja821
Contributor

Re: Combine content of two tables

I have done the same, but getting inappropriate data.

Dimension of which table we have to use after linking.?

tomasz_tru
Valued Contributor

Re: Combine content of two tables

Can you give us a sample of both tables?

Tomasz

sravan_v007
New Contributor III

Re: Combine content of two tables

Hello..

FYI,

- If you have tables with same structure Qlikview will concatinate tables automatically.

   

T1:T2:
NumSalNumSal
110041000
220052000
330063000

Script:

T1:

Load * from XXX;

T2:

Load * from YYY;

   

Result:
T1:
NumSale
1100
2200
3300
41000
52000
63000

- If you have tables with diffrent structure you have to do a force concatenate tables.

   

T1:T2:
NumSalNumExp
110041000
220052000
330063000

Script:

T1:

Load * from XXX;

Concatenate

T2:

Load * from YYY;

 

Result:
T1:
NumSaleExp
1100
2200
3300
4 1000
5 2000
6 3000

Note: When you Concatenate/Generate a relation, the common Field/Primary Key will be only one field(i.e. In the above example Num, from 2 tables, it is concatenated as one single field) .

Highlighted
Not applicable

Re: Combine content of two tables

Hi pooja,

Can you explain the data structure for the 2 tables you are trying to use together. If they are of same structure then we can concatenate. If not need to view the data structure.

sonkumamon
New Contributor III

Re: Combine content of two tables

Hi Pooja,

Check if maybe you have more than one name -  identical column, because if you have than QlikView will create a systematic key based on a couple of columns and not based on the column you want as a 'Primary Key'.

In this case just change the name of the other identical columns.

You can use the dimension from both table