I have a requirement to process excel files present in certain folder. Below is the Folder structure:
Under Main Folder,
To process all the files in Main Folder, I can use Foreach file enumerator and selecting the checkbox 'traverse subfolders' in For each loop container.
However, I need to read the SubFolder Names (EmpA,EmpB,EmpC) to lookup on SQL table to retrieve the EmpID.
Below is the Table structure:
It would be of great help if you could share your experience in case you ever came across similar requirement.