Hi,I would like to ask you if there is a faster way to create separate excel files (each for Order Co) than to filter each table by Order ID and save the results?Example:
Hi @Neffri
Here you go, a Formula that reads in the order numbers and creates a separate output for each order:
hi @Neffri
Step 1: Input tool
Step 2: formula tool
"C:\Users\XXXX\Downloads\"+[OrderCo]+".xlsx|||Sheet1"
Use the part where you want to save the output.
Step 3: Output tool
Output:
If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.
Many thanks
Shanker V
You can do it dynamically with the help out below option in Output tool.
I need to create file for each Order Co and instead of creating for example 30 filters with order co. Can I do this faster? I dont want to create 30 filter with own value.
This below will help.
Input:
Output tool:
I've checked this solution but it's creating one file 'Order Co' with as many tabs as there are different Order Co.
I need as many files as there are different Order Co
hi @Neffri change the option on the output data tool to Change entirefile path
The below article from the knowledge base will help you get more information.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-separate-Excel-files/ta-p/1247
One way of doing this:
yes you're right ! I used filter and I was wondering why my method doesn't work....
Do you know if is possible to create additional sheet for these files with simple pivot like this:
or will be problem because I can save this automatically if I don't have 'order co' field?
Do you need to create additional sheets based on which column Account right.
Separate sheet for 1234 and 34545 seperately.
Shanker
In one file I would like to have 2 sheets: with raw data and with pivot. And now when I'm doing that I need to have Order Co and File column:(
I've attached example of my output.
Try this workflow;
A Block Until Done tool ensures that the first workstream is completely finished before attempting the second (so you don't get errors about the excel file already in use), the second stream summerises as per your output, generates the filepath based on Order Co as it was done in the first stream, using a Select tool to remove the Order Co field, and then adds a new tab called Pivot 180+ to the existing excel file.
