OldField,NewField,Shown,Language,Mapping
Field1,anotherfield,,,
Field2,Field2,,,
Field2,varietyOrSubspecies,,Javascript,"return inputValue.equalsIgnoreCase(""var."") ? ""varietas"" : inputValue.equalsIgnoreCase(""subsp."") ? ""subspecies"" : """";"
Field3,Field3,,,
Field3,naturalised,,Groovy,"inputValue.equalsIgnoreCase(""Y"") ? ""naturalised"" : """" "
Field4,Field4,,,
Field4,unrelatedField,,Javascript,"return (!line.get(inputHeaders.indexOf(""Field3"")).trim().isEmpty() && !line.get(inputHeaders.indexOf(""Field4"")).trim().isEmpty() ? ""Useful"" : """");"
Field5,Field5,,Lua,"return inputValue .. ""a"""

OldField,NewField,Shown,Language,Mapping
Field1,anotherfield,,,
Field2,Field2,,,
Field2,varietyOrSubspecies,,Javascript,"return inputValue.equalsIgnoreCase(""var."") ? ""varietas"" : inputValue.equalsIgnoreCase(""subsp."") ? ""subspecies"" : """";"
Field3,Field3,,,
Field3,naturalised,,Groovy,"inputValue.equalsIgnoreCase(""Y"") ? ""naturalised"" : """" "
Field4,Field4,,,
Field4,unrelatedField,,Javascript,"return (!col(""Field3"").trim().isEmpty() && !col(""Field4"").trim().isEmpty() ? ""Useful"" : """");"
Field5,Field5,,Lua,"return inputValue .. ""a"""

Use col function in javascript mapping test sources
Use col function in javascript mapping test sources