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

[@thinkmetrics]

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

[@abhijeetjoshi-gl9hy]

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

[@thinkmetrics]

🙌🏻🙌🏻🙌🏻

[@rajeshv8012]

Excellent explanation, Appreciate your efforts.

[@thinkmetrics]

THanks!

[@Account2129]

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

[@azadehmshchn4114]

keep up the good work! super helpful

[@thinkmetrics]

Thank you! 🙌🏻

[@304varun5]

Can you please explain how to write complex set expressions

[@thinkmetrics]

Sure.

[@304varun5]

@@thinkmetrics Thank you
especially regarding addyears, addmonths, ytd, qtd and wtd set expressions

[@rams_stuff]

Thanks 👍 for excellent information

[@thinkmetrics]

Thanks

[@vamshikn]

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]);

[@thinkmetrics]

Nice 👍🏻

[@ОлександрКостенко-з1з]

can be even shorter )
LOAD
objectid,
SubField(objectid,'.',-1) as name,
SubField(SubField(objectid,'XY32',2),'.',1) as surname

[@gordonash6031]

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?

[@mangammakashaboina2476]

Superb

[@thinkmetrics]

Thank you 🙌🏻🙌🏻🙌🏻

[@Enaklam]

LOAD * From Perfect_Table Where Data='Clean';

[@thinkmetrics]

hahaha Amazing!!!!!