Compare two excel sheet and get the data as per coondition

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

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?
image

Example:
DATA PROCESSING.xaml (9.2 KB)

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

3 Likes

Hi @lokeshkumar.k

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

Test.zip (170.4 KB)

Thanks,
Harivishnu

1 Like

Thanks for your help

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.