Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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.
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.
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
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