Please help me to implement the below logic in Qlik Sense: I have the names as below: Abc.firstname.lastname@example.org A.de@ gmail.com Aaaaaaa.email@example.com... And so on.. I just want names as: Abc.def A.de Aaaaaaa.bbbbb Please help me Thanks Deepanshu
If you Field is named Email:
subfield(Email,'@",1) as Name,
seems like a typo with double quotes (after @) m w:
SubField(Email, '@', 1) as Name
Thanks for the help
Retrieving data ...