1 Reply Latest reply: Mar 19, 2013 9:13 AM by Gysbert Wassenaar RSS

    Merging fields into fields

    Kalyana Sundaram

      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