Extract only the specific column data from a datatable and create a new datatable with that column data

Hi Guys,
How can I extract only the specific column data from a datatable and create a new datatable with that column data.

Please help me figure out this.

You can use select method or filter datatable activity.

@anussark

Say you have datatable - dt1 of 1000 records and 30 columns

If you want some specific rows from all columns you can do something like
Dt2=Dt1.select(“column name=‘filter option’”).copytoDatatable
Dt2 is new datatable that you want

And if you want some coulms only then

Dt2 = dt1.defaultview(true,“coulm name”)

Dt2 is datatable in which you have single column with all rows

Hope you found my explanation simple

Regards,
Aditya

1 Like

please find the attached workflow
GetSelectedColumnsFromDT.xaml (11.4 KB)

regards,
Pathrudu

1 Like