Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use a preceding load
load *, Tax&Interest&COGS&OtherExpenses&Revenue as NewField;
load ...your current load statements here...