Compare and update excel with bulk datas

Hi everyone ,

My requirement is i have two excels namely 1.jobinfo and 2.jobrelationship with 1000’s of records with many columns i have attached sample of required columns

image datatable 1
image datatable 2

Vlookup ‘EmpID’ against dt2

If ‘EmpID’ not found, skip

  • Filter ‘Relationship Type’ = ‘O&P BP’
  • If the number of rows returned is 0, skip
  • If the number of rows returned is 1, Copy ‘job relation career name’ to 'Career Name’ column in dt1

suggest me linq query for the above query

@Palaniyappan @Yoichi @Rahul_Unnikrishnan @ppr
thanks in advance

Hello @kavya.s16

You can use the vlookup activity to acheive the matched data. Then you can loop through each row in the new datatable and put a if condition to check ‘Relationship Type’ = ‘O&P BP’

what does vlookup do? but i need to update dt1 only and dont need an result dt by doing vlookup @Rahul_Unnikrishnan

can you share 2 sample exxcels

i have attached the screenshot of excel sample since its client data i cant attach excels @Rahul_Unnikrishnan

@weekendCJ this joins dt2 to dt1 which i dont need , instead update the dt1 with dt2 column value