Hi Team ,
In my Input file I have 4 excel files. 3 of which to be used for loop, they have same excel format/column sequencing.
The 4th file is for performing the Find & Replace operation.
I want to create dynamic workflow where , Workflow reads X number of excel file, exclude 1 unique ( for Find & Replace) and perform the operation for each file, and save each file individually in Output folder.
I have attached folders for quick help. In Input folder 3 excel files are ( Jan, Feb & Mar). Help is required to understand how can I read the 3 files (*.csv) one by one and exclude file named ( C A Mapping_MM_DD_YYYY.xlsx).
Perform Find & Replace ( Jan file column D) with C A Mapping_MM_DD_YYYY.xlsx ( column A) and add column in Jan file with column G from mapping file.
Output is required to be saved at Output folder for each file separately.
Solved! Go to Solution.
Hi @atcodedog05 , please find attached desired out for 3 files. Column V is generated via Vlookup in excel vs C A Mapping_MM_DD_YYYY file. Thanks
@SAURABHGHOTKAR
See if this is what you need
Thanks @Qiu , request to share the output as separate files. Attached herewith excepted output folder. Thanks for suggestion.
Here is a workflow for the task.
Input Folder:
Output Data:
Output folder:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @atcodedog05
I am trying to get output in separate files and not in single file. With above solution it seems I can Read multiple input files, however , Output is populating in a single file.
I want to create separate Output file for each month, like Jan_Output, Feb_Output etc
Thanks
I have modified the workflow to reflect filename accordingly
Please check output folder and let me know.