load should fill in the missing values not as null but as 0

[amien]

double post

[amien]

i added this:

drop table basic;

LOAD sum(value), date, filenumber
RESIDENT Calculation
GROUP BY date,filenumber;

drop table calculation;

[#3]

Yep. I used Sum(value) in the pivot table sample I made, so the second field isn't there. This does the same, but while the data is loaded 🙂

Question: why did you add the GROUP BY clause? Just curious.

[amien]

because i'v a additional INLINE table joined. this contains additional filenumber information like maincapital.

when i JOIN this on 2x 200901,1 (date,filenumber) .. then i have 2x maincapital .. when summing that in a pivot .. i have double the maincapital that i need.

Thanks again for your time