Compare two excel

Learning Initatives Automation Starter
1 
           |  parameter to be filed |       Description

Type A | 2345 | Nikhil
Type A | 1256 | Rahul
Type A | | vinay
Type B | 3451 | Ram
Type B | 3456 | kunal
this my first excel

code | Address | Description | mobile_Number
0987 | ssd nagar | Akshay | 1234567789
2345 | Mukti dhaam | Nikhil | 1234567789
1256 | veerbhadra | Rahul | 1234567789
3451 | pawan nagar | Ram | 1234567789
3456 | mukai nagar | kunal | 1234567789

This my second excel

if column type A has code then delete that code row from secod excel ex2345 delete that row from second excel if Type A code not available then goto next line

2

Hello @Namrata_Bhovi ,

  • Read Data and take it into 2 DataTable variables (in_FirstDt, in_SecondDt)
  • Use Assign Activity and use below LinQ

outputDT = in_FirstDt.AsEnumerable().Where(function(row) Not in_SecondDt.AsEnumerable().Select(function(r) r.Field(Of String)(“code”)).Any(function(x) x = row.Field(Of String)(“code”))).CopyToDataTable()

Thanks,
Rohith

3

image
image1051×192 9.06 KB

it gives an error to the assign activity

4

Hi @Namrata_Bhovi

Check the outputDt → Must be in System.Data.DataTable

image

Regards
Gokul

5

In first excel check Type A and Type A have parameter to be filed available then remove that Parameter filed number row from second excel