Need your urgent help - Create the multiple excel file from one excel

Question

Hi Team,

I have below data in excel file. I want to create different excel files based on Field1 data. for example : filter the data on Field1 and create a different files like a.xlsx,b.xls,c.xlsx etc.

Field1       Field2

a              ABC
a              EFD
a              XYZ
b              LMN
b              OPQ
b              STU
b              JKL
c              EFG
c              HIJ
c             KLM

First find the unique value for column a (Field1) in above example it would be a,b,c.

Then filter the data for a , b ,c separately and add into in separate excel files with save name a.xlsx,b.xlsx etc.

Need you uregent help here to create a dynamic workflow where above file select from particular folder and process.

Thank you in advance.

Kenda · Accepted Answer

@alt_tush See the attached workflow and batch macro I created that should help you out. Depending on if the files already exist or not, you may have to change the output settings within the macro to 'Create New Sheet' instead of 'Overwrite File.' You will also want to be sure to change the Formula tool within the macro to save the output files to the correct location on your computer.

Hope this helps!

ponraj · Accepted Answer

Attaching a sample workflow for your case.    Create a new column with output file path and name using formula tool and then configure the output date tool as shown in following image.

Workflow

Output Data tool configuration
Results