Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kalyandg
Contributor II

Merging fields into fields

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

1 Reply

Re: Merging fields into fields

Use a preceding load

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

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


talk is cheap, supply exceeds demand
Community Browser