Hello - this is a snippet from my code. I cannot get the nulls to populate the no payments. I have tried a number of techniques (isNull, len=0, combinations of resident tables etc) but to no avail. Please can you help.
Many thanks, James.
MAPPING LOAD null(),'NO PAYMENTS' AUTOGENERATE 1;
map "Last_Paid" using NO_PAYMENT_MAP; //not sure about quotation marks, single quotes, or nothing at all.
PAYMENTS: LOAD Document_Type, date(Posting_Date) as Posting_Date, CA, Amount as Amount_2 FROM (qvd) where Exists(CA) ;
MAX_DATE: Load CA, date(max(Posting_Date)) as Last_Paid Resident PAYMENTS Group By CA ;
Load CA, Last_Paid
//I also tried... if(isNull(Last_Paid), 'No Payment', Last_Paid) as Last_Paid Resident MAX_DATE ;
DROP TABLE MAX_DATE; MAX_DATE_FINAL: NoConcatenate Load * Resident MAX_DATE_2;