Output to SQL database table - Order of Rows inconsistent

Question

Trying to append records from Alteryx to SQL database table.

It seems the order of data is getting jumbled when I see in database as compared to the order of records which i am tyring to output from Alteryx.

I need the records in database to be in same order as in Alteryx.

cmcclellan · Answer

Trick question though - WHY do you need the records to be stored in a certain order ?  Really, when you query the database later you can sort the records into the order that you want, the way the records are stored shouldn't be a concern at all

AZuc · Answer

@rohan_tibarewala , Alteryx does not control how databases store or retrieves data. This is based on the SQL you send to the database.

If you want your data ordered, choose a field (or more than one) to be used in the ORDER BY clause of your query. If you don't have any, try creating one using Record ID Tool