Hi all, I have two folders to work on. I am trying to get the matching file paths in 2nd folder using the ‘Ref code’ from 1st folder. File name format in 1st folder = RV_ASNUp-[Ref code]-[Date]-[Time].xls File name format in 2nd folder = RV-[Ref code]-[Date]-[Time].xls In first folder, I managed…

Hi @ATO , As per my understand collect the RefCode value from Folder1 files path then check with Folder2 files collected RefCode is Contains with path if yes add to data table. Folder 1 [image] Folder 2 [image] Output [image] Workflow [image] Xaml Sequence5.xaml (15.1 KB)

How to get file path with limited information from a datatable?

Help Studio

ATO December 28, 2022, 2:56am 9

Hi @RajKumar_DC ,

Thanks for the photos and xaml file.
Managed to solve my problem using your steps.

Topic		Replies	Views
Read excel from a given file folder Help activities , question	28	5876	February 24, 2019
Extract all file names in a folder and need to write in an excel Studio datatable , excel , uiautomation , activities , studio , question , folders , activities_panel	12	769	October 19, 2023
Help pull a substring out of a string from a datatable and add to a new datatable Studio	4	697	April 4, 2022
Extracting filename from folder to excel Help datatable , excel , uiautomation , studio , question	9	3009	June 26, 2021
For each file in directory, get path, file name and create date Studio	3	1155	August 18, 2022

How to get file path with limited information from a datatable?

Related topics