Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Assign same string name to all rows in new column - In-DB

FrederikWinther1
5 - Atom

Dear all,

 

Could someone please help me understand how I assign a string, e.g., "Actual" to all rows using the in-db formula tool?

 

I know how it works in the "normal" formula tool, but for the life of me I cannot figure out how to do it in in-db formula tool.

 

Normal formula:

Formula.png

 

In-DB formula:

image.png

 

Which returns the following error:

 

image.png

The error must come from the fact that Alteryx/SQL interprets my formula as a call to a column named "Actual". However, I simply want to create a new field "File" with the string value "Actual".

 

Thank you!

3 REPLIES 3
JoeS
Alteryx
Alteryx

SQL uses single quotes for strings rather than double quotes.

 

Switch it to 'Actual' and that should give you what you need.

RolandSchubert
16 - Nebula
16 - Nebula

Hi @FrederikWinther1 ,

 

replace the double quotes by single quotes ("Actual" -> 'Actual'). It's according to SQL syntax then and should work.

 

Best regards

 

Roland

FrederikWinther1
5 - Atom

I knew it was simple, but not that it was that simple. 

Thanks for the help!

Labels