Output File

sgaryali

Hi

I want to generate output file on he bases on column H which contains Name of the manager.

So like for ex Manager Name - Rahul I should get output for that emp id  who has Rahul as their manager

And likewise as many as manager I have it should keep generating the output.

Manager Name is not fixed It can be more or less for each month.

Can we do that?

Output Sample Data.xlsx

atcodedog05

Hi @sgaryali 

Create filename in format [FilePath]+[Manager Name]+".xlsx|"+[SheetName] in formula and set output tool to change path for each manager group like below. This generates files for each Manager group.

Workflow:

Hope this helps : )

Akshay.xlsx

Diksha.xlsx

Filename.yxmd