Write dynamic output to a formatted excel file

Question

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.

Qiu · Answer

@Mary319Horne 
There is an on-going discussion, which you can refer.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Exporting-to-Template-Formatting-Issue-for-First-Row-of-Data/td-p/1402405
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Splitting-Out-Template-based-on-Column-Value/td-p/986296

Jerlyn05 · Answer

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.