Hi everyone,
I have a workflow as a sample attached. I just want to get output in the position of sheet 2 in an excel file. Means, I want to set an order in the excel file which I am getting from output in this workflow where Sheet1 should be empty and my output excel file should be at the 2nd position.
What should I do in the attached workflow to get the attached sample output.
Thanks!
Solved! Go to Solution.
Here's how you can ensure the order of the sheet in your workbook
The top part of the workflow writes an (almost) empty sheet as sheet1. It's not completely empty, since you have to pass something to get the sheet created. In this case there is a single space in cell A1. The bottom part is your workflow with a synchronizer block added to ensure that the empty sheet1 is finished and the file is closed before sheet 2 starts writing. The Sync block summarizes the output of the top part into a single row, which is unioned with the data from your workflow. The filter and select tool remove the added row and then the added column to pass your data unchanged to the output.
Dan
Thank you so much for the response. However, it is giving me one excel file only as an output.
How can I get separated files as mentioned in the path group (name) ?
Thanks!
@Rahul_Analyst if you want multiple Excel files you need to have a field with the full path, then use this field in the output data tool. Example: C:\Users\username\Downloads\File1.xlsx|||Sheet1.
@gabrielvilella , @danilang and I have used it in the workflow. Please see my attached workflow field name is created (path) and used it in output.
However, I think still somewhere we unable to use it with untill block tool to get the desired output.
Thanks,
Rahul
@Rahul_Analyst on your data output tool you have the Alteryx Database file format. Please change it to Excel and overwrite sheet.
Thank you, Emil. It worked.