June 26, 2014 at 1:31 am
Hi All,
I have a requirement to process excel files present in certain folder. Below is the Folder structure:
-Main Folder
Under Main Folder,
--EmpA--File1,File2
--EmpB--File1,File2
--EmpC--File1
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:
EmpID EmpName
1 EmpA
2 EmpB
3 EmpC
It would be of great help if you could share your experience in case you ever came across similar requirement.
Regards,
Maninder
June 26, 2014 at 1:51 am
You can capture the current iteration's file path in a user variable.
Have a look at the Variable Mappings section here[/url] and let us know if you need more info.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 26, 2014 at 3:37 am
Thanks Phil.
Creating user variable and Using Substring Function (to retrieve sub folder name) in Derived column transformation worked for me 🙂
Cheers!
Maninder
June 26, 2014 at 3:42 am
Great, well done.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply