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