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

    Excelfiles with different number of fields

      Hi,

       

      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