topic issue in inserting and deleting fields in QVD in QlikView

issue in inserting and deleting fields in QVD

Wed, 26 Mar 2014 11:54:28 GMT

Hi,

I have a QVD file by name ABC, which has fields as ID, Email_ID, Name etc....

Now i have to Split Column Email_ID into 2 columns like Name(XYZ) and Domain(rediffmail.com) with out using join, concatenate as i am doing this to optimize QVD performance, can anyone please suggest me on this...

Re: issue in inserting and deleting fields in QVD

tresB — Wed, 26 Mar 2014 12:00:41 GMT

Try like:

ABC:

Load

ID,

SubField(Email_ID, '@' , 1) as Name,

SubField(Email_ID, '@' , 2) as Domain

From ../... ABC.qvd(qvd);

Store ABC into .../.. ABC.qvd(qvd);

Drop table ABC;

Re: issue in inserting and deleting fields in QVD

Wed, 26 Mar 2014 13:17:36 GMT

Thank you so much, Its helpful

Re: issue in inserting and deleting fields in QVD

Wed, 26 Mar 2014 13:40:26 GMT

How to i concatenate Name & Domain fields in the expression in front end designing?