Compare two excel sheet and get the data as per coondition

[lokeshkumar.k]

APP1.xlsx (8.7 KB)
test1.xlsx (8.7 KB)

I attached two excel sheet Test1 and App1.

Select the “Sr.no” one by one in “Sr.no” column in Test1 and check that Sr.no is available in App1
If Sr.no not available in App1, put comment as SR not found in “Comment” column in Test1 for that Sr.no

If Sr.no is available in App1, Check the “Status” column in App1
If status column value is “Not Open” in App1, put comment as SR Mismatch in “Comment” column in Test1
If status column value is “Open” in App1, Check the “Type” column in App1

If Type column value is “Not LI” in App1, put comment as SR type Mismatch in “Comment” column in Test1 for that Sr.no
If Type column value is “LI” in App1, go to next Sr.no in Test1

[Pamela_Sibaja]

Hi Lokeshkumar,

In mi case, I used the LINQ query to match the correct comment.
Do you need this result for the data table named Test1?

Example:
DATA PROCESSING.xaml (9.2 KB)

Have a great day!
Please let me know if you need anything else.

[anon88744563]

Hi @lokeshkumar.k

Kindly Check the .xaml
" it will Easy to Understand for your Process"

Test.zip (170.4 KB)

Thanks,
Harivishnu

[lokeshkumar.k]

Thanks for your help