Formula tool - Quotation as part of output ?

Question

I am using a Formula tool to create a column that contains a formula as a string to run using an excel API (once output to a file). I need the resulting value in the column to contain quotations, but I am unable to write the expression in a way that the output contains the quotes where needed. Is there a way to do this ?

I've tried adding a +Char(34) where quotes are needed and I've tried including the " as part of free text being appended as part of the formula but continue to get an error

Current Formula -- "=BDP (" + [BB ID] + "," + " INT_ACC, " + "SETTLE_DT, " + [CLOSE_BUS_DATE] + ")"

The output shows as =BPD (12345, INT_ACC, SETTLE_DT, 2025-10-27)

I need the output to look like this, with quotes included as part of the text, shown in red

=BDP("12345", "INT_ACC", "SETTLE_DT", "2025-10-27",

12345 = [BB ID]

2025-10-27 = [CLOSE_BUS_DATE

abacon · Accepted Answer

@Jimsac333 Try this -

Current Formula -- '=BDP ("' + [BB ID] + '","INT_ACC","SETTLE_DT","' + [CLOSE_BUS_DATE] + '")"'

Basically, if you want double quotes to be apart of the text, use single quotes first to tell alteryx it's a string, then you can include double quotes within the single quotes. A little confusing but it works.

Of course... you may have to mess with the structure of this formula to ensure it is coming out exactly how you want it, but the answer is to use single quotes to tell alteryx it's a string, then include the double quotes within them.

Bacon