Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Concatenate Numeric Fields in Summarize Tool

It would be nice to be able to concatenate numeric values (integers, doubles, etc.) directly in the Summarize Tool.

 

I know this would involve converting it to a string on the backend, but I don't believe there would be any data loss when going from numeric to string. I know this can be done by using other tools like Select of Formula to convert to string before the summarize but I don't see any reason why this couldn't be accomplished in a single tool.

 

pfiskrat_0-1672938971429.png

 

 

Thanks,

Paul

2 Commentaires
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Statut modifié en : Accepting Votes
 
Kalposki
Météore

Hi Paul, 

 

I just found out that if you use a Select tool to convert the data from numeric to string, run the workflow and then "Delete and Connect Around" the Select tool, the data will be concatenated as numeric values in the Summarize without having to change its type.

 

Only problem to this ; the output of the Summarize tool will be displayed as V_String 🤡  We still need to convert its type afterward.

 

It's just funny to learn that you can "force" a data type.