3 Replies Latest reply: Feb 29, 2012 8:52 AM by Syed Khaled Shahbaaz RSS

    Concatenate load of Excel sheet that doesn't yet exist.

      Good Morning, Got an interesting scenario thats popped up, im running a report that imports vast  amounts of data from Excel into Qlickview.

       

      Usually when you have to load more than 65,536 rows of data, the data will spill into a new tab called sheet2$

       

      im trying to future proof my report so that when sheet 2 is fully populated it will then pull data from sheet 3 so on and so forth

       

      On the XLS file I am importing  these sheets dont yet exist and Qlickview wont let me future proof my report by naming the tabs to be loaded in a future event without me having to go back and modify my report ever month or so.

       

      The code ive used so far.

       

      Source_Data:

      LOAD [Contract A/C] as CA,

      Balance as Amount

      FROM

      [*.xls]

      (biff, embedded labels, table is Sheet1$);

      ;

      Source_data2:

      Concatenate

      LOAD @1 as CA,

      @3 as Amount

      FROM

      [*.xls]

      (biff, no labels, table is Sheet2$)

      ;