5 Replies Latest reply: Aug 23, 2016 8:35 AM by SENTHIL KUMAR MUNIYAPPAN RSS

    Excel Sheets with Same column names in QlikSense

    SENTHIL KUMAR MUNIYAPPAN

      Hello All,

       

      I am quite new to the QlikSense.

       

      I have an excel file with multiple sheets (yearly data) say 2005, 2006, 2007, 2008, .... All worksheets have the same column names. I would like to upload the entire file at once. I am unable to load the data AS IS since the same columns appear in other sheets.

       

      e.g.:

      Sheet name is 2010

      columns are as follows:

      Country

      Project Code

      Headcount

      Sales

      Expenses

      Budget

      ...

       

      then the sheet name 2011

      columns are the same as 2010, i.e.

      Country

      Project Code

      Headcount

      Sales

      Expenses

      Budget

      ...

       

      Please guide me. Thank you in advance.

       

      Note: I checked for answers from previous discussions, but unfortunately I found one that pertains to QlikView and not for QlikSense.