2 Replies Latest reply: Apr 4, 2018 1:29 PM by David Forest RSS

    Concatenate all the sheets in an excel work in Qlik sense

    Anand kumar

      Hi folks,

       

      I have data in each sheet of work book with common fields and each sheet in excel work book is a category

       

      No I would like to loop through all the sheets available in the work book and concatenate them while looping

       

      I tried using the help from the following post but as Im using Qlik sense I am getting the error as it can connect only to Lib connections

       

      I tried replacing the path with Lib but even then it is not working and is failing at odbc,

       

      can some body help me on this

       

       

      @Jonathan Dienst

      can you please help


      Thanks in Advance

       

       

       

      Loading from multiple Excel files and multiple sheets