BellaDati Technical Documentation : Data cleansing

Icon

Goal of this use case is to clean the values from imported data file.

Icon

You can download data for this use case here.

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)

 

Icon

This function will be used for all the values which contain selected string. If you want to update only specific values, you can also use conditions, like following:

if (value(1) == 'UK') {
return "United Kingdom"
}
return value(1)

Attachments:

sales.csv (text/csv)