Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Concatenating 3 tables in Data manager (in Qlik Sense)

Dear All,

I have to load 3 sheets (with same no. of columns) from same Excel files to Qlik Sense and then I want to unpivot these 3 tables (still maintain same no. of columns after unpivoting) and concatenate them into 1 big table. I can concatenate any 2 of them but when i try to concatenate the 3rd one, an error message will pop up! Anyone knows what is the possible root cause of it?

Qlik 1.png

Best regards,

Janice

3 Replies
Anonymous
Not applicable
Author

Supplement, below is the error message when concatenating the 3rd table to the previous 2 which are already become 1 table:

Qlik 2.png

priyalvp24
Creator
Creator

Hi,

Will you please load the data through data load editor & send the error?

Thanks,

Priyal

Anonymous
Not applicable
Author

Concatenate 3 tables in data manager (in Qlik Sense)

Can you please go to above page to download the script in data load editor? this is auto-generated script.

the 3 sheets are named NB, POS & Claims. i want to combine them into 1 table named agent survey. Hope my questions is clear to you.