Message Tool Not Converting Count Records Tool Result to String Correctly

Question

Designer Desktop Version:  2021.4.2.07064

Issue: The "Message Tool" is returning wrong values when converting Int64 result from "Count Records Tool" while using a "Message Expression" with a "ToString" function.

This incorrect conversion does not happen when:

* Using AMP Engine
* Specifying a "NumDec" value in the "ToString" function.
* Using a "Formula Tool" to create the Int64 value before the "Message Tool"

I understand that you can use the "_RecordNumber_" variable instead of the "Count Records Tool" but that does not change the fact that the tool is failing to convert int64 datatype properly within the "Message Tool". I discovered this does not happen when the Int64 comes from a "Formula Tool" first, I do not know if this is only affecting the "Count Records Tool".

Attached is a sample workflow where you can see the differences.

Message Tool Int to String.yxmd

ChrisTX · Answer

I didn't have a problem with AMP on or off, in 2022.3.1

I can't find that specific issue as Fixed in Designer Release Notes (alteryx.com)

Maybe ask Alteryx support if it is a known issue, already fixed?

Seems to be fixed in 2022.3.1

pfiskrat · Answer

This issue does not happen when using AMP Engine.

ChrisTX · Answer

I'm not seeing that issue with AMP on, using version 2022.3.1

In your 2021 version, do you have the Workflow Runtime configuration option for "Engine compatibility mode"?