QlikSense Data Cleaning challenge: Learn how to use Len,left, right, Index, subfield to clean data. 

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

Best Ever explanation on the topics related to Qliksense on entire youtube.Hats off Thanks a lot

Excellent explanation, Appreciate your efforts.

Thanks 👍 for excellent information

This worked for me! Without using the len, index functions load *, SubField(first_lastname,'.',1) as first_name, SubField(first_lastname,'.',2) as last_name ; LOAD objectid, SubField(objectid,'2',1), SubField(objectid,'2',2) as first_lastname, SubField(objectid,'.',1) FROM [lib://DataFiles/datacleaningfile.xlsx] (ooxml, embedded labels, table is [data cleaning]);

keep up the good work! super helpful

Superb

10:21 why do we need to do an alternative load? Why can't we just add the code to the end? Thanks

Can you please explain how to write complex set expressions

Great video - how would you find the first occurrence of a non-numeric after the XY32 ? Like if there was a XY33 we couldn't use the literal in the index clause?

LOAD * From Perfect_Table Where Data='Clean';