Multiple tabs on Differnt Excels with multiple outputs

Question

Hi,

I have 4 different excels with 20 tabs each (each one representing a cost center). On each of the 4 excels the cost center tabs match. However I need 20 different outputs for each of the cost centers (so 1 tab from each of the 4 excels would be 1 completed workbook) Is there a way to not have to individually select each on the input where I can take the 4 original excels and have the output run 20 different workbooks?

Thanks!

Kim

Kim2 · Answer

Hi,

I seem to be getting errors, so not sure if its exactly what I need. I attached some files below to better explain what I am trying to do. On the 4 Alteryx test files - these are what come right out of my system and I then need for each tab to create a file that looks like the "C6CH Output needed" . So for these examples I would need 3 different outputs that look like the C6CH but for the other tabs in the Test files.

Thanks!

Kim

C6CH Output Needed.xlsx

Corp Funct-HR Exp AL - Alteryx Test.xlsx

Corp Funct-HR Exp Detail AL - Alteryx Test.xlsx

Corp Funct-HR Trend AL - Alteryx Test.xlsx

Corp Funct-HR Trend PY - Alteryx test.xlsx

MattBSlalom · Answer

This scenario is perfect for a Batch Macro.  The Control Parameter will be used to drive selection of a single source Excel file / sheet.  The sample below is a workflow that gets sheet names then calls a macro to take action on each sheet.

The macro will handle the activities you'd perform against a single sheet like writing it to a separate Excel file.  The macro will be called by a parent workflow that passes in the list of sheets to take action on.  In my sample macro I've got a placeholder Container with a dummy Filter tool that you'd replace with any actual logic needed on the data in a given sheet.

Simple parent workflow to gather sheet names and pass into batch macro:

Sample Batch macro to process 1 sheet at a time:

WriteExcelSheetsToNewFiles.yxmc

ProcessExcelFiles.yxmd