Message Tool Not Converting Count Records Tool Result to String Correctly
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This issue does not happen when using AMP Engine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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