I need to match the the column layout and names on the ‘Files’ tab match what is in the Errors file attached here. Within the automation, this is the datatable ‘dtFiles’
In order to make the fields match, i need to add logic to extract the date from the raw string. Right now I’m just pulling out the filename and filesize.
Can anyone please suggest how can i do it?Errors .xlsx (647.7 KB)
Main.xaml (45.6 KB)