Pass information from one column to another

I have a Datatable with a column (“Status”)
In the column, there are the lines (“YES”) and (“NO”)

If the row of column(“Status”) = (“YES”)
I need to pass the Column rows to another datatable

Can anyone help?

Hi @Hendrix_Santos
You can use add datarow to add that row to datatable based on if condition provided based Status Column

1 Like

HI @Hendrix_Santos

You can try this

  • Read the excel file(read Range)
  • Filter Datatble(Condition : “Column name” contains “YES”) save in new datatable
  • Write range and write that in new sheet or excel file

Can you provide sample input ?


1 Like

Hi [Hendrix Santos,
Please follow this workflow


1 Like

Going line by line, the robot takes a long time because the database is huge, would there be a faster and clearer solution?

1 Like

Yes solution by @Sudharsan_Ka would be faster :slight_smile:


Thank You Peoples :slight_smile:


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