Merging fields into fields

kalyandg — Tue, 19 Mar 2013 12:56:48 GMT

Hi All,

I have to extract the below fields from random data as the following script

"if(Acct_Type='PL',if(WildMatch(AcctName, '*TAX*')=1,AcctName)) as Tax,

if(Acct_Type='PL',if(WildMatch(AcctName, '*INTEREST*')=1,AcctName)) as Interest,

if(Acct_Type='PL',if(Category='Cost of Materials Consumed',Category)) as COGS,

if(Acct_Type='PL',if([Sub Category]='Other Expenses',[Sub Category])) as OtherExpenses,

if(Acct_Type='PL',if(Category='Revenue',Category)) as Revenue,"

Now I have to merge all these fields into a single field, how can I do?

Please help me to solve this.

Thanks in Advance,

Kalyan

Re: Merging fields into fields

Gysbert_Wassenaar — Tue, 19 Mar 2013 13:13:00 GMT

Use a preceding load

load *, Tax&Interest&COGS&OtherExpenses&Revenue as NewField;

load ...your current load statements here...