Write dynamic output to a formatted excel file

[Jerlyn05]

Hi everyone,

Is there a way to write my dynamic output to a formatted excel file? There are columns that are dynamic and I just want to adjust the formatted template based on my dynamic output.

Below is my alteryx output with fields NP_REL_1_ECI all the way to NP_REL_7_ECI. 

 I want to be able to insert these additional fields to the formatted excel file and just move the rest of the fields automatically since the template normally includes fields NP_REL_1_ECI and NP_REL_2_ECI only. I hope there's a way to do it.

[Jerlyn05]

When you say "adjust the Excel template to account for the maximum number of dynamic columns'' means I need to manually add columns on my template? What I hope to achieve is that the field name "BUS_IN" will just automatically move to the right side to automatically accommodate the additional fields that my workflow produced.

[Qiu]

@Mary319Horne 
There is an on-going discussion, which you can refer.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Exporting-to-Template-Formatti...
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Splitting-Out-Template-based-o...