Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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;
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;
Thank you so much, Its helpful
How to i concatenate Name & Domain fields in the expression in front end designing?