Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Message Tool Not Converting Count Records Tool Result to String Correctly

pfiskrat
7 - Meteor

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:

  1. Using AMP Engine
  2. Specifying a "NumDec" value in the "ToString" function.
  3. 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.

 

Untitled.jpg

 
 

 

3 REPLIES 3
ChrisTX
15 - Aurora

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

 

pfiskrat
7 - Meteor

This issue does not happen when using AMP Engine.

ChrisTX
15 - Aurora

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

Labels