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

Tips and Tricks

Accepted answers

All comments

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

Alteryx Workflow_v1y.yxzp

Category_Profitability Report_Furniture.xlsx

testing file.xlsx

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:

Alteryx Workflow_v1y.yxzp

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703