Order of records changing when being outputted to SQL Server

[saqib]

 Hello all,

We have a Alteryx workflow which output data to a SQL server. However Alteryx for some reason changes the order of the rows when the data is written to the SQL server.

Using the Browser tool, we can verify that the sequence is correct. But when the data is outputted to SQL server order is not maintained.

I added the RecordID tool right before the SQL Server output tool. The re-ordering is evident from the screenshot below (see around Row21/RecordID 22)

Please advise.

Thanks.

[BenMoss]

Interesting, not something I've ever noticed before.

As a temporary solution  could you perhaps look at writing a post SQL statement in the options which performs the order by on the ID field.

I can't look into this in more detail right now but will look out for it in the future!

[saqib]

@BenMoss, can you please suggest a POST SQL command to achieve this? Thanks.

[BenMoss]

Here's a link:

https://www.w3schools.com/sql/sql_orderby.asp

Ben

[BenMoss]

Not sure that would work actually, surely that's just pinging another query rather than writing over the table with the ordered table. Unless you use the order by and then write.

[Ringo]

4 years later and this is still not working, i.e. Alteryx reorders sorted data.