Add constant to an Expression

  • 20Views
  • Last Post 11 December 2018
  • Topic Is Solved
0
votes
Ivo Dimov posted this 10 December 2018

Hi,
Is it possible to add Constant to an Expression when we upload a CSV file. For example, I would like to add s string value (Household) to a field called Name. So the field I populate contains = Name (Household). I tried expression, and i triead just (Household), but would not work. I also added '  and ", but still the same issue. I could not find any sintax info in the Documentation. Is it even possible to do this?

Order By: Standard | Newest | Votes
0
votes
Ivo Dimov posted this 10 December 2018

I was very lucky, and honestly I just guessed. So for anyone who has the same problem, you need to use + to combine fields, and also " " to identify space and also if you want to add a contstand you should use "Household". It would have been so much easier if this is in the documentation, especially for simple examples like this one.

0
votes
Mariia Zaharova posted this 11 December 2018

Hello Ivo! Skyvia uses SSIS syntax for Expressions: 

https://docs.microsoft.com/en-us/sql/integration-services/expressions/operators-ssis-expression?view=sql-server-2017

0
votes
Ivo Dimov posted this 11 December 2018

Hi Mariia,
Thank you for the information. Much appreciated.

Close