7 Replies Latest reply: Sep 8, 2016 8:38 AM by rafael scalabrin RSS

    load excel columns

    rafael scalabrin

      Hi, I have some data on excel workbooks and I need load it on Qlikviwer. Its only one table, but some months it comes with or without some columns, I cant specify when, but its always to put it in the same table, is there a way to load it creating the column on the select? and saying to put "-" in the cells, if the column not exists??

       

      For example:

       

      january.xlsx
      A    B    c
      1    1    1   
      1    1    1
      
      FEb.xlxs
      A    B
      2    2   
      2    2
         
      
      MARCH.xlsx
      C    D
      3    3
      3    3
      
      
      QLIKVIEW RESULT
      A    B    C    D   
      1    1    1    -
      1    1    1    -
      2    2    -    -
      2    2    -    -
      -    -    3    3
      -    -    3    3