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

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

    Marco Curreli

      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)