output column in excel not in order

[adarsh2608]

I have a workflow which will calculate the last 10 years along with the last 7 months' data in output , every time when i run i get correct data as output as expected but at the beginning of the month data changes and not order , in the output workflow of alteryx i see correct order but in the excel order changes. every time i need to readjust the save it in order to get in the correct order .

[IraWatt]

Hey @adarsh2608,

I assume you are using the Table tool to output a table with the render tool. Could you have changed the order in the Table Tool:

[adarsh2608]

Hello @IraWatt ,

Even in the table it is in correct order but only in the excel output it deosn't come in correct form, since it is in ofc laptop , i couldn't upload the workflow but i have shared the screenshot

[IraWatt]

@adarsh2608 Does running this workflow with AMP engine off change this? To turn it off click on the canvas then select runtime in the configuration menu then untick use AMP. Also have you use the brows tool pinpoint the exact point it goes out of order from the table tool? If it's fine all the way up to the render tool I would report this to the support team, open a case here: Support - Alteryx Community

[adarsh2608]

ya AMP is off and ya in browse tool it is showing correctly , i guess let me create a case with team