Extracting a particular column from a data table

[subham.dey]

Hi,
I an using CV scope activity to extract the data and save it in a data table. Now i want to extract a particular column from the data table and store it in another data table.

[lrtetala (Lakshman Reddy)]

Hi @subham.dey

DT.DefaultView.ToTable(False,"YourColumn")

Regards,

[Kanak_Lata_Singh]

Hi @subham.dey

Please refer below

Select column from datatable

assign this to a new Datatable variable [image] new DataView(dt).ToTable(false,new List(Of String)({"ColumnName"}).ToArray) to select multiple columns (ColumnName1 and ColumnName2) to new DT new DataView(dt).ToTable(false,new List(Of String)({"ColumnName","ColumnName2"}).ToArray)

[pradeep931 (Pradeep Bandharam)]

Hi @subham.dey

Try using the Filter DataTable activity on the specific column you need, and it will generate a new DataTable.

[subham.dey]

Thanks @pradeep931 , this worked.