Recode multiple columns with list
I want to recode multiple columns using a conditional formula by going through each column with a For Each function. I am not able to recode successfully with the following code:
//Create list of columns to be recoded
ColNames = {dt:Name( "col 1" ), dt:Name( "col 2" ), dt:Name( "col 3" ), dt:Name( "col 4" )};
For Each( {listitem}, ColNames,
Recode(
listitem,
{Lowercase( _rcNow ), If( Conta
...