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?
Add constant to an Expression
- Last Post 11 December 2018
- Topic Is Solved
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.
Hello Ivo! Skyvia uses SSIS syntax for Expressions: