Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
da_pagnott
Contributor III
Contributor III

Connections between tables

Hello guys,

I have a questions about connections, and maybe someone can helpo me please..!

 

Do I have any way to connect two tables with two common fields?

I have two data sources, with different format, but with customer name and data value in commod.

I'd like to merge values in my dashboard in one single table because I have some customer in one table and some in the other one. I need then to split values per month, so maybe I have to set a connection also between data fileds?

Please find attached an example of my actual association.

 

Thank you very much!!

Labels (2)
2 Replies
Ivan_Bozov
Luminary
Luminary

Hi, you can create a key field like this:

Table1:
FieldA & '-' & FieldB AS Key

Table2:
FieldC & '-' & FieldD AS Key
vizmind.eu
Channa
Specialist III
Specialist III

u can do concatenate between two tables to make union

 

try to have same number of columns and data formats

Channa