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: 
Not applicable

Combine several excel sheet in only one

Hi,

I'm new on Qlik sense and I do not have a huge developper background let's say...

I've a double issue while loading an excel file. The excel file contains 70 sheets named "ID1, ID2, ID3...". In each sheet, there are several information about the ID.

1) I would like to create a column in each sheet with the ID number. (Same ID number for every rows in the sheet)

2) I would like to combine all those sheets into only one.

The expected result is to have all the sheet combined in one with a column that tell to which ID this rows is related. Hope it is clear.

I assume that it is possible through the script but I've no idea on how to start...

May some of you have any ideas ?

Thanks a lot.

Alexis

1 Reply
marcus_sommer

Take a look on this: Loading Multiple Excel Sheets Dynamically along with file name and sheet name and you could add recno() and rowno() to this loading to identify each of your records.

- Marcus