Hello again,
I have a template excel file to use as output. I want to keep each sheet in order to keep it formatted but rename sheets dynamically. Also, If possible I'd like to be able to change sheets order.
I hope you can help me, thanks
Happy to be wrong, but I don't think this is possible. Your options are rename the sheets in the template file, or use Python/R/Run Command Tools.
It's a shame but looking from another angle is there anyway I can get a friendlier output? I just need the columns to be adjusted to the size
The basic Output Data Tool output is a little dry. Have you considered using Table Tool → Render Tool? You can create multiple tabs that way and have formatting options. There are other posts, but here is one of somebody doing that: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-tool-multiple-tabs/td-p...
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |