Compare the specific column values in excel sheet and append those value to another excel sheet

Help
, ,
1

How to compare the specific column values in excel sheet with all other values and how to append the those values if the values are same, to another excel sheet?

2

Hi @PAVI3399,

This will help you,

3

Hi @PAVI3399 ,

  1. Take Excel Application Scope.
  2. Read Range - Sheet data in a DataTable - Say dt_input.
  3. Iterate the Datatable(dt_Input) using a For each .
  4. Compare row(“value you want to compare”) = “value to be compared”

5.Take an AddDataRow Activity and add the row from step 4 to it.(Create a new Datatable here - dt_Final)

–
Mukesh

4

Hi @PAVI3399

This can help !

image
image444×660 15.9 KB

Properties of AddDataRow
image

–
Mukesh