Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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
16 - Nebula
16 - Nebula

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
16 - Nebula
16 - Nebula

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
Top Solution Authors