Expression understanding

[smilingjohn]

Hi Expertise ,

Can anyone please help me understand the below script 

Pick(WildMatch(if(IsNull(

Thanks in Advance

[abhijitnalekar]

Hi @smilingjohn,

provided expression  

First, check if a field is null or not, and if null then defines the 'NoModes' value.

second, it searches the strings in the fields and define the specified values to it using pick and match function

[AshutoshBhumkar · Accepted solution]

Hello,

below steps are being performed in the above code

1. Check if LABEL has null values, replace those with 'NoModes', rest values remains same.

2. If above generated field contains '*Mode0*','*Mode1*','*Mode2*','*Mode3*','NoModes','*' (with wildcard search)

then give appropriate values from 'Mode0','Mode1','Mode2','Mode3','NoModes','NoModes'

and create a field called LABEL

Thanks,
Ashutosh