Excel automation folder

Hello, I am a beginner, trying to build this use case.
"Scenario Task :-

Step 1. Read data from YOB and Gender excel file and automate:

Step 2. For every unique YOB create a Folder in Output Folder. For e.g. for YOB of 1992, create a folder Output\1992

Step 2. In each YOB Folder, create 2 xls file viz. Male.xls and Female.xls. Male.xls should contain Emp ID, First Name, Last Name, YOB and Gender for all Male employees born in that year.

Simillarly FeMale.xls should contain Emp ID, First Name, Last Name, YOB and Gender for all Female employees born in that year.

need suggestions and steps to build this scenario

Thank you.

Hi @vamsilver43

Check the workflow specified in the link

Interview Task

Hope it helps you

Mark it as solution if you got it

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

Hi @NIVED_NAMBIAR
Thank you it is working

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.