From every column's script, you can access other columns by functions:
Function value\(x) returns value of a x-th column of the import
Function name\(x) returns name of the x-th column of the import
and include the results into the current column's script.
Samples
Separating a column containing full name into two first name and surname:
Script for first name:
return capitalize(substringBefore(value(1), ' '))
Script for surname name:
return capitalize(substringAfter(value(1), ' '))
Overview
Content Tools