Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've dimensional field called "SKUTheme" (string), using this field need to create calculated dimension based on below condition.
if above filed 2nd character/letter contains number then 'Non-Theme' else 'Theme'.
note: below expression is working but i'm looking some alternative expression/ simplified method.
=if(SKUTheme='A1','Non-Theme',
if(SKUTheme='A2','Non-Theme',
if(SKUTheme='A3','Non-Theme',
if(SKUTheme='A4','Non-Theme',
if(SKUTheme='A5','Non-Theme',
if(SKUTheme='A6','Non-Theme',
if(SKUTheme='B1','Non-Theme',
if(SKUTheme='B2','Non-Theme',
if(SKUTheme='B3','Non-Theme',
if(SKUTheme='B4','Non-Theme',
if(SKUTheme='B5','Non-Theme',
if(SKUTheme='B6','Non-Theme',
if(SKUTheme='C1','Non-Theme',
if(SKUTheme='C2','Non-Theme',
if(SKUTheme='C3','Non-Theme',
if(SKUTheme='C4','Non-Theme',
if(SKUTheme='C5','Non-Theme',
if(SKUTheme='C6','Non-Theme',
if(SKUTheme='C7','Non-Theme','Theme'
)))))))))))))))))))
Tks, dev
Hi Devarasu,
You can try this expression:
If(len(SKUTheme)>=3,'Theme','Non-Theme')
Regards
Miguel del Valle
Hi Devarasu,
You can try this expression:
If(len(SKUTheme)>=3,'Theme','Non-Theme')
Regards
Miguel del Valle
Hi,
I think is better to create a new field in the script, then using calculated dimension, for optimization reason.
Best regards,
Cosmina