ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

Multi-Row formula should ‘export’ records in the same order as they came in.

Status: Accepting Votes Submitted by 12 - Quasar on ‎12-21-2022 04:21 PM
3 Comments (3 New)

Shouldn't have to stick a sort after every Multi-Row formula to reorder the records back to the same way they entered the tool.  Simple

See more ideas labeled with:
3 Comments
cgoodman
ACE Emeritus
ACE Emeritus
‎12-22-2022 03:02 AM

Have you noticed this change with a more recent version of Alteryx? It might be due to the way the AMP engine processes the data in packets. The sort should be maintained if you turn on Compatibility mode in the workflow settings.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
‎01-04-2023 11:00 AM
Status changed to: Accepting Votes
 
0 Likes
SeanAdams
17 - Castor
17 - Castor
‎06-20-2023 12:52 PM

Hey @Watermark - do you see this when you're running in compatability mode?

Reason for asking is that AMP is multi-threaded, so it doesn't guarantee sort order (that's the cost of multi-threading since you do things in parallel).

 

Would you see this as a feature request to have an option on the multi-row to say "return in original order"?

 

 

0 Likes
Labels