Concatenation and Cross Table

[apthansh]

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;

[swuehl]

Try

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;