1 Reply Latest reply: May 4, 2017 11:19 AM by Marcus Sommer RSS

    Combine several excel sheet in only one

    Alexis cohenen

      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