Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! 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

Highlighted
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) .

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