4 Replies Latest reply: Jan 23, 2017 12:52 PM by Marco Curreli RSS

    Use external (xls) list as filter in data load editor

      Hi all,

       

      I'm hoping someone can help me pointing into right direction.

      I'm trying to load a list of values (field ambiti in tab_ambiti) and I want to use them as a filter in where clause in table conformita_new.

      How can I do this without a join betwwen tables?

       

      Thx

       

      Marco


      tab_ambiti:
      LOAD
          ambiti
      FROM [lib://AttachedFiles/ambiti.xls]
      (biff, embedded labels, table is Sheet1$);
      
      Qualify *;
      Unqualify key_1, COD_LOC_CONTROLLO;
      
      
      conformita_new:
      LOAD
          COD_LOC_CONTROLLO&SUBJECT_AREA&DT_ESEC_CONTROLLO as key_1,
          COD_LOC_CONTROLLO,
          COD_LOC_AZIENDA,
          DT_RIF_CONTROLLO,
          RUN,
          DT_ESEC_CONTROLLO,
          "MONTH",
          DT_ESEC_CONTROLLO_MM,
          %KO,
          CRITERIO_ITA,
          SUBJECT_AREA,
          DT_AGGIORNAMENTO
      FROM [lib://QVD (spimi_qlikadministrator)/esiti.qvd]
      (qvd)