Hii,
My requirement is like i have one excel input file and 1 .mht input file which i need to scrapped it and store it into a datatable.Then i need to Compare the Columns of Each input file. But the requirement is like sometimes we can get two .mht files also sometimes three .mht files also. So for one excel file we can have any number of .mht file and we need to compare the excel file column with all these number of .mht files.
So, I m not getting how i will automate this through RPA.
What if number of input file increase in future.
I Assume that files are in some Folder say targetDirectory
Take an assign activity and create a variable of type Array of String - Lets call this Excelfiles and use the below expression to get all the Excel Files - You can have a more specific Filter like excelName instead of *