Preserving the format of output file

[Kamran1991]

Dear community members,

I am working on building a workflow, where I am preserving the format of output file.

Will it be possible if we can retain this format for multiple output files, generated through batch macro?

Any help will be highly appreciated.

Thanks,

Kamran

[DataNath]

Hey @Kamran1991, the whole idea of a batch macro is that it is ran each time under the exact same conditions, just changing the control parameter each time. Therefore, if your Output Data step is part of the macro that'll ensure that all files output from it are of the same type etc.

[Kamran1991]

@DataNath ,

Thanks for the guidance.

Having considered your input also, there is still no success.

[DataNath]

@Kamran1991 can you give some extra context? Perhaps some screenshots, or even better, your workflow with a detailed description of what you're trying to achieve? Happy to take a look if so. Thanks!

[Kamran1991]

@DataNath 

I am attaching the Alteryx package with source and output files.

Please select the profitability report file in the output of batch macro.

There are three categories in testing file and i want profitability report for the all categories.

Will be highly thanks for your help.

Kamran

[DataNath]

Hey @Kamran1991 you had these GroupBy fields set in the Group By tab of the batch macro which shouldn't have been. If you just change the first to None, the second will blank out like so:

Then, in the Questions tab of the configuration, just ensure you have Category selected:

When you run the flow now:

Outputs:

[HomesickSurfer]

 @Kamran1991 

Make use of the config options in the Output Data Tool to append or overwrite a range.

This will preserve not only formatting but also any data validation, comments, etc.

[Kamran1991]

There are multiple input files, so this option will not work.

[HomesickSurfer]

Hi @Kamran1991 

I'm uncertain what the input files have to do with the outputs you wish to retain formatting of.  Please explain.  I believe that the solution I have proposed does work.

[Colgan]

It's interesting that Alteryx doesn't use the Excel standard of having a ! after the workbook name  example:  [MyWorkbook.xlsx]Sheet2!$A$1:$Z$10001 it creates Sheet2! rather than  the expected Sheet2