Loading from csv and want to creat a new column and sort the data in every field alphabetically

[jgraunke77]

Hi there,

I'm loading some data from a csv-file. One of the columns includes email-addresses. Now I want to create a new column and want to delete every double characters and sort the rest alphabetically.

For example...

LOAD id,
             timestamp,
             email
FROM C:test.csv
(txt, utf8, embedded labels, delimiter is ',', msq);

I want:

LOAD id,
             timestamp,
             email, 
             sortedmail
FROM C:test.csv
(txt, utf8, embedded labels, delimiter is ',', msq);

in the first row there is in column "email" the value: waynetrain@whateverest.com...
I want in same row in column "sortedmail" the value: aeinrtwy

[saar_lorena]

You can load your table and use an Order By E-mail.

Example:

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-sort-data-in-data-load-editor-and-assign-orde...

[jgraunke77]

Thanks for your reply... I think, I've explained it wrong... 

I'm loading:

ID	Timestamp	email
384	2019-06-26 06:35:41	waynetrain@whateverest.com

and I want:

ID	Timestamp	email	sortedmail
384	2019-06-26 06:35:41	waynetrain@whateverest.com	aeinrtwy

[Brett_Bleess]

I think you may need to attach what you have in the way of qvw file and possibly the csv file(s) as well on this one for someone to further help you.

Regards,
Brett