Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

janice-st
New Contributor II

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
janice-st
New Contributor II

Re: Concatenating 3 tables in Data manager (in Qlik Sense)

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
Contributor

Re: Concatenating 3 tables in Data manager (in Qlik Sense)

Hi,

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

Thanks,

Priyal

janice-st
New Contributor II

Re: Concatenating 3 tables in Data manager (in Qlik Sense)

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.