Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

Combine similar fields into one from three different data sources

Hi

I am loading data from QVDs, XML. I have a common field called customer Name. I am very much new to qliksense. I want to know how to join these tables to have a single CustomerName.  

Example:

 

Table1:

customerid, Customer_Name 

from abc.qvd;

 

Table2:

Companyname, Customer_Name 

from xyz.xml;

Table3:

AmtSpent,Customer_Name

from pqrst.qvd;

 

I want to have a single field called Cust_Name; 

I tried using concatenate. It's concatenating first two tables but not the table3. 

 

Please help.

 

Labels (2)
1 Reply
Lisa_P
Employee
Employee

You do not need to combine these tables to have a single field. They will be associated based on common field name and internally one common field is created with all field values in what we call a symbol table. Joining is not required to see all values.