issue in inserting and deleting fields in QVD

[#1]

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

[tresesco · Accepted solution]

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]

Thank you so much, Its helpful

[#4]

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