Dear All
I have given below script and it has been attached multiple excel file and crosstable field in BCOD,CATAGERY AND DESCRIPTION. I already hard cord description field as this
Load
Description,
if(match(Description,'GROSS PROFIT','Direct Expenses','Apportioned Direct Expenses','Direct - Other Income','Indirect Expenses','Mgt Fee - Apportioned Indirect Expenses','Indirect Income - Investment'),Description) as NARATION
Then, Description field include following item , (Gross Profit ,Direct Expenses , Apportioned Direct Expenses) then I want new item in that given below
Gross Profit - Direct Expenses - Apportioned Direct Expenses as Profit aft Direct Expenses
Please help get a above item and add a Narration field as this
Load
Description,
if(match(Description,'GROSS PROFIT','Direct Expenses','Apportioned Direct Expenses','Direct - Other Income','Indirect Expenses','Mgt Fee - Apportioned Indirect Expenses','Indirect Income - Investment','Profit aft Direct Expenses'),Description) as NARATION
My script
CrossTable(cata, Data, 3)
LOAD *
FROM
(biff, embedded labels, table is HO$);
Thanking You
Sagara