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