4 Replies Latest reply: Nov 26, 2013 11:26 AM by Alan Farrell RSS

    Excelfiles with different number of fields



      i'm trying to load a number of excelfiles into qlikview. My problem is that not all files has exactly the same fields,

      i.e. not all fields exists in all files. 

      Is there a way check if a field exists or not in the load-function?


      For example:
      File1 has fields: A,B,C,D,E


      File2 has fields: A,C,D


      File2 is missing fields B and D. 


      There's about 25 files and sometimes it ca be up to 10 fields missing, which makes changing the data a bit complicated