Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

issue in inserting and deleting fields in QVD

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...

1 Solution

Accepted Solutions
MVP
MVP

Re: issue in inserting and deleting fields in QVD

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;

3 Replies
MVP
MVP

Re: issue in inserting and deleting fields in QVD

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;

Not applicable

Re: issue in inserting and deleting fields in QVD

Thank you so much, Its helpful

Not applicable

Re: issue in inserting and deleting fields in QVD

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

Community Browser