Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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;

View solution in original post

3 Replies
tresesco
MVP
MVP

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
Author

Thank you so much, Its helpful

Not applicable
Author

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