Load Csv & Group by

[#1]

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.

[tresB · Accepted solution]

try this:

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 TOTALAMOUNT

RESIDENT dtf Group By CALLING_IMSI, TARIFF_PLAN;

[suniljain]

You forget to add Tariff_Plan in group by clause.

[#4]

Thank you very much..

I think i have to study SQL statements much more...