Output data into multiple excel files with the file's order as it is in Alteryx workflow

Hi all,

I have done the output data into multiple excel files in 1 folder as advised here

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-data-into-multiple-files/td-p/142665

However, all the excel files output are sorted in the order of the folder's rule like File name ascending or descending, which i do not want like the 1st picture. 4 excel files are will be sorted from American home to Dea chang kum.

I want the order is the same as my rules in the workflow, for example the Fee column as descending in the 2nd picture, Dea chang kum excel file first and American home will be the last file.

1st pic:

2nd pic:

Anyone has a solution for this?

Thank you in advance!

Common Use Cases

Data Investigation

Documentation

Accepted answers

Qiu

@HungCuong_HCM
I went back to the post you mentiond as reference, so I think we can do the following.

1. Add a Record ID tool before output.
2. Formula for new path:
"C:\<Your Directory>\" +Tostring(RecordID)+'-'+ [Field value to use as file name] + ".xlsx|||<Sheet Name>"

All comments

rkapoor

@HungCuong_HCM are you able to attach your workflow here or a screenshot?

Are you sorting by the Fees also in your workflow?

HungCuong_HCM

Hi @rkapoor ,

Thanks for your reply! Sorry i can not upload the workflow due to confidentiality. But yes, i did sort the fee in my workflow and i would want the output files are sorted as the order of my workflow but it keeps the sorting order of the folder.

Is this information enough or what else do you need? Please share!

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703