Usecase with REFramework,Excel Vlookup and FolderCreations and DataCategorization based on input Data

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.

Gender.xlsx (9.3 KB)
YOB.xlsx (11.5 KB)

Simillarly FeMale.xls should contain Emp ID, First Name, Last Name, YOB and Gender for all Female employees born in that year.
Usecase2.zip (11.4 KB)

Attaching the RE Framework workflow with this. You can try the use case and if struck somewhere, check the workflow attached for hints.

Thanks for sharing this

1 Like