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?

[atcodedog05 · Accepted solution]

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 : )

[binu_acs · Accepted solution]

@sgaryali smiliar approach like @atcodedog05 

[atcodedog05]

Happy to help : ) @sgaryali 

Cheers and have a nice day!