Unflattening Multi-Select Picklists

PoC of a not best practice solution to working with everyone's least favorite data type, the Multi-Select picklist.

Formula for myFlat on parse3:

case when multiCount ZZZ 3 then null when multiCount == 3 then substr(myMulti__c, index_of(myMulti__c,";", 1, 2) +1, (len(myMulti__c) - index_of(myMulti__c,";" ,1, 2))) else substr(myMulti__c, index_of(myMulti__c,";", 1, 2) +1, index_of(myMulti__c,";", 1, 3) - (index_of(myMulti__c,";", 1, 2) +1)) end

Note: The less than symbol isn't supported in youtube descriptions, so ZZZ is where that should be.

[RahulSingh-sjje]

Hi Pete, I am trying to replicate the steps you have performed. However, I am unable to
uncheck
'Is Multivalue' on sfdcDigest myMulti node. After unchecking the checkbox and saving when I check back I see the 'Is Multivalue' is checked again. By default Einstein is making it checked.