Output File Preparation

Ragini1

Hello Everyone,

I am trying to create an Output file that has the following tabs:

1. Overview

2. Validation

3. Additional Information

The validation tab is created by Company Code. There are around 20 Company Codes, so 20 Output files will be created.

However, I want to add the Overview and Additional Information tab in all 20 files. I want to automate the process.

Can someone please guide me on how can I achieve this?

Regards

MattBSlalom

This sounds like you want to use a Batch Macro.  Here's a write-up from a similar question:  Re: How to build iterative process - Alteryx Community

For your scenario, the Macro will be the process for a single Company including the output of the 1st & 3rd sheets.

The parent workflow will pass in the list of Company Codes to iterate over, resulting in 20 files created.