Hi,
Does Alteryx have a function to construct sentences like in Excel? mixing numbers in the data set?
for example the below:
= "Month on month change of $"&'data tab'X6:X6'&"due to a surge in sales..."
Yep! You may want to look at the report text tool in the reporting category https://help.alteryx.com/current/designer/report-text-tool
Alternatively, you could construct a string with a formula tool where any numeric field you just wrap with ToString([Field]) and then use a plus to combine them.
Hi @yzhang
You'd use a + (plus) char to concatenate string characters. if you need to concat a numeric field, just wrap it first in a TOSTRING() function.
'Month on month change of $'
+ TOSTRING([MoM_val])
+ ' due to a surge in sales...'