I have script as below...Is this correct was of concatenating ? as Description is not merging together ..
Expense:
Load
ID,
Description,
Expense,
Rent,
Non-Rent
from Table a;
OtherExpTmp:
crossTable(Description, Cost, 1)
LOAD
ID
Insurance,
Rent,
Depreciation,
Other
FROM Table B;
Concatenate Expense:
Load
ID,
Description,
Cost,
if(wildmatch(Description,'*Rent*'),'Rent','Non-Rent') as [Rent-NonRent],
if(wildmatch(Description,'*Rent*'),Description) as [Rent]
Resident OtherExpTmp;
drop table OtherExpTmp;
