Multi-Row Formula & Join Tools Sorting Data Incorrectly

[musabsalih66]

Anyone having some issues with the Multi-Row Formula, Join, and Summarize tools resorting the rows in their outputs?
It seems like the common denominator amongst these tools that are causing this issue is using the "Group By" function within tools or if it is embedded in a tool such as the Join tool. 

This was not happening up until a week or two ago so I'm wondering if there was any change or if anyone noticed the change?

[jrlindem · Accepted solution]

Can you try turning AMP off and seeing if that resolves the issue.

Also, adding a Record_ID could also help re-establish the sort order but obviously doesn't help you summarize tool use.

Given that this just started popping up, let me ask the obvious:  Did your Alteryx version get updated to coincide?

[Qiu · Accepted solution]

@musabsalih66 

I would also suspect that AMP engine is turned on as @jrlindem commented.

[musabsalih66]

Yup! You guys are right! It is in fact AMP Engine screwing things up.

Thanks a lot gents!