Loop not working

I want to compare two excel sheets somehow i can do that but my loop is not going to the next file in directory.

I might made smalData Validation.xaml 1 (22.2 KB)
l mistake can someone correct my xaml file.

Thanks in advance.

Regards,
Lawrance A

can u explain the process or u may share the sample file

Better practice is to create first list or array or enum as variable and next put this to for each

Create variable, type Ienumerable, then value -> directory.enumaretefiles(path)

Hi Pranesh,

Requirement :

I have two excel files one is from supplier and another is my sheet Excel - A which is from supplier is having two sheets sheet is one is general info and sheet 2 is part wise info RPA should read Excel - A Sheet 1 and take variable from that it will apply filter table in Excel - B once its done next it should read Sheet 2 which will have part wise data for this for each row RPA should compare with Excel - B once all the row compared it should closed Excel - A and another supplier file should start compare.

Present status:

I have developed as explained above but the problem is its comparing each row from Excel - A sheet 2 with Excel - B once its done its not taking next supplier file it shows no more error in Excel - A and then its throwing error .

Requirement :

I have two excel files one is from supplier and another is my sheet Excel - A which is from supplier is having two sheets sheet is one is general info and sheet 2 is part wise info RPA should read Excel - A Sheet 1 and take variable from that it will apply filter table in Excel - B once its done next it should read Sheet 2 which will have part wise data for this for each row RPA should compare with Excel - B once all the row compared it should closed Excel - A and another supplier file should start compare.

Present status:

I have developed as explained above but the problem is its comparing each row from Excel - A sheet 2 with Excel - B once its done its not taking next supplier file it shows no more error in Excel - A and then its throwing error

Can you explain how to use this syntax and where should i use this ?