3 Replies Latest reply: Jul 22, 2013 6:35 AM by Lorenzo Biancofiore RSS

    Load Csv & Group by

      Hi everyone,

      i'm a newbie in using QlickView and i'm having some trouble creating a load script.

      When i debug the script, system answers "Invalid expression" and i don't understand why...

      Here is my code:

       

      dtf:

      LOAD

           CALLING_IMSI,

           TARIFF_PLAN,

           AMOUNT

               

           FROM

      DTFprove.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      where AMOUNT > 0;

       

      Join (dtf)

       

      LOAD

      CALLING_IMSI as IMSI,

      TARIFF_PLAN,

           sum(AMOUNT) AS AMOUNT

          

      RESIDENT dtf Group By CALLING_IMSI;

       

      Thanks a lot!!!

      L.