Different input files, 1 output workbook with multiple tabs

[bluecosmo22]

I am new to alteryx, i have searched around havent seen anything like what im trying to do, can someone share?

Input Files:
Report 1

Report 2

Report 3

Then on the output file, the workbook will be organized

Output file, tab 1, Report 1

Output file, tab 2, Report 2

Output file, tab 3, Report 3

[abacon · Accepted solution]

@bluecosmo22 The first is a way to do it if the incoming reports are formatted the same but have different data. The second one is a way to use a macro to remove null columns in the case of your reports having different schemas.

If this solution works for you, please mark it as the solution so others may find it faster.

[bluecosmo22]

Awesome, worked as intended!