Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Concatanate in DB

fborgmann
6 - Meteoroid

Hello everybody,

 

I am trying to concatanate two existing fields in one field using the in DB formula tool. 

While trying, I recieve the following error message. Is there another way to do it or can you see a mistake in my syntax? 

 

Thanks for advice!

 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @fborgmann ,

 

When you are using IN DB components, you must use the formulas that your DB allow you to use. For example, when you are concatenating columns in SQL Server, you must do CONCAT('wil_code''dtc_code'). And you must be sure that the columns that you are concatenating  are strings to do that, because this function is for strings.

 

Felipe_Ribeir0_0-1663512698012.png

 

 

https://www.w3schools.com/sql/func_sqlserver_concat.asp 

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

Labels
Top Solution Authors