Goal of this use case is to clean the values from imported data file.
Use contains function to transform values into the same value for all the rows. First you should define all the wrong appearances and then create condition for all of them. This function will update all the columns which contain selected string.
if(contains(value(2), 'wasser')) {
return "Water"
}
if(contains(value(2), 'Warter')) {
return "Water"
}
if(contains(value(2), 'water')) {
return "Water"
}
return value(2)