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: 
pooja821
Creator
Creator

Combine content of two tables

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

6 Replies
shun_wong
Partner - Contributor III
Partner - Contributor III

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
Creator
Creator
Author

I have done the same, but getting inappropriate data.

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

tomasz_tru
Specialist
Specialist

Can you give us a sample of both tables?

Tomasz

sravan_v007
Partner - Contributor III
Partner - Contributor III

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

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
Creator
Creator

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