IF Statements in Expression

  • 18Views
  • Last Post 15 June 2018
0
votes
Ben Willis posted this 15 June 2018

Is it possible to use if statements in an Expression Mapping when doing a data import.

For example:

 

IF(Field1 = "X","AB",
IF(Field2 ="Y","ABC",
IF(Field3 = "Z","ABCD",
A
)))

0
votes
Mariia Zaharova posted this 15 June 2018

Hi Ben!

Please refer to:

https://skyvia.com/resources/docs/index.html?expressions.htm

https://msdn.microsoft.com/en-us/library/ms141680.aspx

 

For example, IF Expressions can be written like this: 

Field1 == "X" ? AB: ABC

Field1 == "X" ? "AB" : (Field2 == "Y" ? "ABC" : "A")

 

If you have any further questions, feel free to contact us.

 

Best regards, 

Mariia

Close