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), ' '))
  • No labels