Hi… i am trying to solve the following usecase with StudioX activities:
- I have a list of lets say 126 files in column “File_Name” of sheet ‘File_list’ in the excel sheet File_list.xlsx
- I need to search for all these files listed row by row from column “File_Name” in let’s say directory c:\Projects\TestFiles
- If a file with a part of filename listed in ‘File_Name’ column of excel sheet matches with one of the files in directory C:\Projects\TestFiles
- A flag ‘Y’ should be written against the filename which matches in the same excel sheet ‘File_list’ under another column named “File_Exists” else the value of flag should be ‘N’
Can anybody help me out with the workflow to achieve this ?
Appreciate your inputs on this!