Output multiple files with multiple sheets based on columns

pratap19

Hi experts,

I am looking for a help.

I am doing one project and struct with the below issue.

The Data: 

Grouping Complex	Location	Pay Scale Group	Pay Scale Level	Rate	Increase Amt	Increase Percent	New Rate
Van Buren Plant	Location A	BG01	01	16.04	0.46	0.028678	16.50
Van Buren Plant	Location A	BG01	35	16.14	0.46	0.028501	16.60
Van Buren Plant	Location B	BG01	01	16.24	0.46	0.028325	16.70
Van Buren Plant	Location B	BG01	35	16.85	0.46	0.028325	16.70
East Texas Live	Location D	BG01	01	15.9	0.5	0.031447	16.40
East Texas Live	Location E	BG01	35	16.1	0.5	0.031056	16.60
East Texas Live	Location F	BG01	40	16.2	0.5	0.030864	16.70

The requirement:

The flow needs to create multiple workbooks based on column "Grouping Complex" and each such work book should contain multiple sheets based on column "Location".

In this case for example, there will be 2 workbooks.

1) Van Buren Plant   -   contains 2 sheets

                                     1. Location A - 2 records

                                     2. Location B - 2 records

2) East Texas Live   -   contains 3 sheets

                                      1. Location D - 1 record

                                      2. Location E - 1 record

                                      3. Location F - 1 record

PFA data file. Thanks in advance.

Data Example.xlsx

Felipe_Ribeir0

Hi @pratap19 

Please see the attached workflow. The secret here is to build a output filename with the formula and take this filename to use as location on the output tool. With this logic you will be able to specify exactly which excel file/sheet name each record must be written.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

multiplesheets.yxzp