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!
Solved! Go to Solution.
SQL uses single quotes for strings rather than double quotes.
Switch it to 'Actual' and that should give you what you need.
Hi @FrederikWinther1 ,
replace the double quotes by single quotes ("Actual" -> 'Actual'). It's according to SQL syntax then and should work.
Best regards
Roland
I knew it was simple, but not that it was that simple.
Thanks for the help!