Loop not working

Help
1

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

2

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

3

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

4

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

5

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 .

6

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

7

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