Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Join in data load editor

Hello,

I have 6 files that I need to join together in the data load editor, please can someone help with how I would do this. 

The files are:

Red1, Red2, Red3, Blue, Green, Yellow

Each file has the same amount of columns (12) and share the same column names, I just need to join them in QS 

If someone could help, that would be great

Thank you in advance

Labels (2)
5 Replies
sidhiq91
Specialist II
Specialist II

@Anonymous Since there are 12 columns in all the 6 files.  We need to rename the column names using the Alias for 11 columns and connect with 1 common key to all the 6 files. 

Or if we can also use the concatenate function and merge all the 6 files into 1 single table.

if this does not sort out the issue, please provide me some sample data and I will help you out.

Chintam
Contributor II
Contributor II

Hi, In Qliksesne  it will Autoconcatenate into one table if the file structure is same (like all your 6 files are comprised with same field names), you can create a Flag with your File name in script at each file load to identify from which file your values are populating. "Red1" as Flag, etc.

After this you can make your transformations or aggregation by using a Resident load. 

 

Mani2920
Contributor
Contributor

use joins if they have the same field names
martinpohl
Partner - Master
Partner - Master

as suggested, a concatenate would be the right way to load your datas into your datamodel. Qlik Sense works a little bit different so think different.

Regards

Saurabh_K14999
Contributor III
Contributor III

Hi,

For the above condition if you are having 12 columns sharing the same column name it will auto concatenate and all the tables will get join together in one table

eg:-

Red1:
LOAD * INLINE [
ID,NAME,SALES
1,ABC,342
2,XYZ,232
];

Red2:
LOAD * INLINE [
ID,NAME,SALES
1,ABC,323
2,XYZ,321
];

Red3:
LOAD * INLINE [
ID,NAME,SALES
1,ABC,644
2,XYZ,653
];

Similarly you can add your 6 tables together and they will get join.

For other condition If you are having less fields in some tables then you will have to rename the rest columns keeping the unique column name same in all tables to avoid getting synthetic keys.

Regards,

SK