Dynamic Output Template
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
Could you please let me know, if there is a solution for my problem/project?
I am building a tool which will combine 4 raport for one entity into one excel file, I will need to combine approximately reports for 100 entity.
I was asked to provide the output file with a template - basically I need to add 4 additional sheets into existing file/template.
The tricky part for me is that the file name will be represent by the entity ID, which means I will need to take a output template add new sheets and save a file with a proper name in one run for 100 entities.
Is it possible to use the Alteryx magic to achieve this?
Thank you in advance for your support
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mateusz_Pietrzak , yes this is possible. You can use the Run command tool to create an run a batch file to copy an Output Template to the name of the 100 entities, then use your workflow to update the template. It works nice because you can format the Excel templates to have the nice formatting on the header row, freeze pains filters, etc. In an example I use, I put the Totals row in column 2, and use the Excel sum formula, to sum everything from row 3 downwards. I'll dig out an example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mateusz_Pietrzak ,
See the attached example. If you create a folder C:\Temp\Dynamic Output\ and save the workflow and the sample template to that, it should work. The update for whatever folder path, template you have. When you run the workflow, it will create a copy_template.bat batch file which will copy the template to the output files. If you've any issues, run the .bat on it's own to see if there's any errors within that. I hope that helps and is what you're after ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @markcurry
Thank you!
I used your advice and I have solved the issue with a run command tool. My project was simpler then I thought and it was enough just to get the file names, put them into script, update the file name and copy files with a run command.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mateusz_Pietrzak you're welcome! Glad it helped.
![](/skins/images/6E37D63E5763CE129B8E3AEB0F348EBD/responsive_peak/images/icon_anonymous_message.png)