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 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 ? Regards Sudharsan

Pass information from one column to another

Help Something Else

Sudharsan_Ka (Sudharsan Ka) July 5, 2022, 11:53am 3

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 ?

Regards
Sudharsan

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Excel skip row Academy Feedback datatable , excel , uiautomation , activities , string , question	9	2312	April 30, 2020
Copy dataTable row to another dataTable Help datatable , excel , activities	13	20179	October 29, 2018
Add a new column having values dependent on another column Help excel , activities , question	8	1001	January 30, 2020
Compare data from data row of mulitiple columns data in datatable? Help	5	1549	May 13, 2019
How to find entire data in one column to another two excel Studio datatable , excel , studio , question , use-excel-file , linq , excel-scope , datatable-filter , excel-tables , join-data-tables , linq-query	1	1142	September 16, 2021

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Pass information from one column to another

Related Topics