Dynamic Macro- Read files from Input Folder and Write to Output Folder

[kal-tech]

Can anybody help me to write a macro to read multiple excel files from the input folder and write into output folder. The output files should look like same as it is in the output folder.  I am able to write a workflow to read multiple files via input files. But not successful to write each file into output folder.

Attached : Files.zip

[Yoshiro_Fujimori]

Hi @kal-tech ,

If you want to keep the original format, you may want to use BLOB Input/Output Tools.

I hope this helps.

Workflow

Formula

FullPath = Replace([FullPath], "Input-File", "Output-File")

[Qiu]

@kal-tech 
Is this similar with this one?
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Loop-Thru-Excel-files-in-a-fol...

[OTrieger]

@kal-tech 

I'm not usre exactly what is the issue, however if you would like to write each one separately then your output tool need to be inside the Batch Macro and I can see that there is an Macro Output tool in your automation. The minute that you have a Macro Output the data will be union.

[kal-tech]

Qiu - Yes, this is somewhat similar to loop-Thru-Excel-File.

Hi All:

Attached Workflow.zip File contains
1. Input Folder – ABC-Input.xlsx & XYZ-Input.xlsx
2. Output Folder - ABC-Output-Chart.xlsx & XYZ-Output-Chart.xlsx
3. WorkFlow Folder – Macro & Workflow

When you run the workflow, it calls macro. It read each file from Input folder

1. It creates “ABC-Output-Chart.xlsx” in the output folder. The sheet1 contains
Data, Pass/Fail bar Chart & Complete/Incomplete Bar charts.
2. Same for XYZ input file. It creates “XYZ-Output-Chart.xlsx” in the output folder. The sheet1 contains Data, Pass/Fail Bar Chart & Complete/Incomplete Bar charts.

Requirement:
1. Each output file should have 3 Tabs (a) Data (b) Pass-Fail (c) Complete-Incomplete instead of dumping all in the sheet1.
Can anyone have suggestion how to do that.?