3 Replies Latest reply: Mar 6, 2015 11:41 AM by Marco Puccetti RSS

    Where Not Exists

    Marco Puccetti

      Hello, can you help me to understand this script:

       

      TABLE A:


      LOAD IBAN,

        IBAN AS IBAN_KEY,

        STATO_TMP AS STATO

      Resident FLUSSO_A;

      Concatenate

      LOAD IBAN,

        IBAN AS IBAN_KEY,

        'BLANK' AS STATO

      Resident FLUSSO_B

      WHERE NOT Exists(IBAN_KEY,IBAN);

       

      In particular can you explain me how is it used the "Not Exits" formula and its meaning?

       

      Thanks