Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have an issue with some data and I'm fairly sure it's a tricky one.
I have the following basic script;
GlobalData:
LOAD Value,
ValuationDate,
SchemeMemberKey
FROM
Currently when I load this and put the data into a straight table it shows me blanks where the member has no contribution within the month. I can't count these blanks though as they don't actually exist within the data so what I need to do is add a 0 value against each member where there's a month that they haven't contributed.
That will then allow me to complete a member count into different categories, including members that have a contribution at the start of the year but not the end etc.....
I hope that makes sense as this one has stumped me for at least 2 days!!!
Please try this to eliminate the blanks:
GlobalData:
LOAD Value,
ValuationDate,
SchemeMemberKey
FROM
where len(trim(Value)) > 0;
Or if you want replace blanks with 0's
GlobalData:
LOAD if(len(trim(Value)) = 0, 0, Value) as Value,
ValuationDate,
SchemeMemberKey
FROM