I recently came across an unexpected (for me!) behaviour of Alteryx: I had built a batch macro that was receiving single letter arguments (a-z
) in the control parameter, and the macro was working OK sometimes, but not all the time. It took a while to figure it out:
Alteryx interpreted f
and t
as Booleans, even though they were defined as strings
My workaround consisted on adding an extra character (so aX
, bX
,…, zX
) in the main workflow and a LEFT(field1, 1)
formula inside the macro. Download the sample workflows here. And see below a graphic summary.