Search for value in another Excel and place the total value in 2 different column corresponding to that value

Help Studio
, ,
10

@HELZMOTH_BJ

follow the steps

  1. read excel 1 into datatable dt
  2. use excel file activity and give the second excel
  3. use for each row in excel with required sheet
  4. inside loop use filter datatable on dt with currentrow("Enployee Name").ToString and use contains in column Reqestor Name
  5. Now use lookup datatable and lookup for light and internet and fill the value using assign …currentrow("Light") = value from lookup for lgiht and similarly for internet

cheers