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

[FrederikWinther1]

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:

In-DB formula:

Which returns the following error:

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!

[JoeS · Accepted solution]

SQL uses single quotes for strings rather than double quotes.

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

[RolandSchubert · Accepted solution]

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]

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

Thanks for the help!