5 Replies Latest reply: Dec 11, 2017 4:37 AM by Seref Keser RSS

    Usage of Excel table:different columns with same content

    Tom Müller

      Hi together,

       

      I've got a little issue with an excel-sheet, I created for the usage in QLIK. The sheet looks like this:

       

      Zeit.JPG

      As it can be seen, I have several columns, that contain the same content: Projekt and Zeit.

      In fact the table could look like this also:

       

      ProjektZeit
      16-0000016:00
      16-0000027:00
      16-0000034:00
      .................

       

      As it is easier for me to design the excel sheet like seen above, I would really like to keep it like it is. Is it possible to integrate this form of sheet in QLIK, so that I could tell QLIK f.e. to create the field "Projekt" as a list of all seen six columns of Projekt and elsewhise with "Zeit"?

       

      Thanks for the replies and best regards,

      Tom Müller