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:

       

       

      denial_article:

       

      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';

      endif;

      next file;

       

       

      but this does not seem to work...

      Can you help me to find the way out?

       

      Thanks in advance