Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
You forget to add Tariff_Plan in group by clause.
Thank you very much..
I think i have to study SQL statements much more...