Can Alteryx create a string of texts and numbers into a sentence?

[yzhang]

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..."

[BrandonB]

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.

[jrgo]

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...'