How to select multiple column from a datatable

Help
1

Hi All,

I have a data table where I have multiple columns.
I have to select some column from the data table and insert into a new data table.
I am using Invoke Code Activity and added code but it is giving me object reference is not set to be an instance of an object.

Dim abc As New DataTable()
abc.Columns.Add(“UserID”)
in_DataRow = (From p In in_ExcelData.AsEnumerable() Select abc.LoadDataRow(New Object() {p.Field(Of String)(“UserID”)}, False)).ToList

1 Like
2

@Ritesh123

You can use the FilterDataTable Activity
In output columns Tab : specify columns you want to keep or remove
Save the Result to new Datatable

image

https://docs.uipath.com/activities/docs/filter-data-table

–
Mukesh

1 Like
3

@Ritesh123

Directly use Filter Data Table activity after getting the main data table.

select “output column” option

Then enter the names of column you wan to keep select remove option if u want to remove the columns

image
image1920×1080 132 KB

1 Like
4

Hi,

Thanks for the feedback but i can not use Filter Data table Activity.
I want to do this with invoke code activity where i can write vb.net code.
Also, i have two data table and i used join with on both of the table and then i have to select some field from both table.

5

Hi @Ritesh123,
It may helps you.
yourdatatable.defaultview.totable(false, “Col 1 name” , “Col 2 name”)
Best Regards,
Likith Rajesh.

2 Likes
6

Good morning Ritesh,

The simplest solution would most likely be using the “Join Data Tables” activity in combination with @likith_rajesh’s solution above.