3 Replies Latest reply: Jan 1, 2017 10:12 AM by Emanuel Zeilinger RSS

    Read data from Excel file in Load Script

    Emanuel Zeilinger

      Hey folks,

       

      I'm pretty new with Qlik.

      Task:

           I want to read in the following Excel row by row.

           Because the values of each row belong together.

           Excel_File.png

      Problem:

           Qlik conclude my data per column.

           In column C (Datei / Tabelle) Qlik is not showing 7 times 'UBPERP', instead there is only one time 'UBPERP'.

           It seams like Qlik is loading each column distinct.

          

      My Code:

           Here is my code including the debug information in the comments.

           Code.png

      Question:

           How can I prevent Qlik from loading distinct?

           Or is there any other approach to do this?