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.
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.