6 Replies Latest reply: Jul 1, 2015 3:59 PM by Ira G RSS

    join load from files where exists a certain field

      Hi guys,


      I am 'fighting' with QlikView  Skript and have a question. My problem is that I have different Excel Files, each containing different Fields (some are common, some not). What I want to do is to load everything only from files containing field 'Denial' with value 'Yes'. I have tried to do that with:





      For Each file in filelist('pathtoFiles\*.xlsx')


      let findfield = FieldNumber(Denial, '$(file)')


      if $(findfield) > 0 then

      join load * from file (ooxml, embedded labels, table is Data) where Denial = 'Yes';


      next file;



      but this does not seem to work...

      Can you help me to find the way out?


      Thanks in advance