Expression mapping allows using simple and complex expressions and formulas to transform source data into target field values.
To use expression mapping, first click the Column list and select Expression. Then enter the expression in the box.
Expression mapping uses different syntax depending on whether old or new data integration engine (runtime) is used. You can determine the engine your package uses by selecting the Use new runtime check box on the tab bar.
Old integration runtime uses Microsoft SQL Integration Services expression syntax. You can find the information about it in Microsoft documentation
New integration runtime uses our own expression syntax that is described in Expression Syntax.
You can find more information about main syntax differences in the Main Differences between Old and New Runtime Syntax topic.
If your package uses new runtime, you may not only enter expressions in the box, but also use a helpful expression editor. You may open the expression editor by clicking the button.
Expression editor lists the operators that you can use in the bottom, and all the available source columns and functions on the left. You can click them in order to quickly add them to your expression. You can also click the in order to quickly find the required column or function.
Additionally, the Expression editor provides syntax highlighting and code completion. To use code completion, simply start typing the expression in the Expression editor, and Skyvia will show all the suitable identifiers and functions. For functions, code completion can even display the argument list.