How to filter data table columns dynamically

RPA Discussions
,
1

i have datatable with more than 200 columns but i need 100 columns only which are randomly located in data table. is there a way to get those 100 columns using headers thru coding / make it dynamic to select what ever column i want instead of activity studio?
Note:- i want to filter specific columns not rows in a datatable.

2

Hi @gsunilusa,
Try below query
Dt=DataTable.DefaultView.ToTable(false,"col1","col2","col3")

Regards
Arivu

3

Hi ,

The column names can be used in Filter data table in output columns and give nothing in conditions .
Or
The linq can be used and select only required columns in Assign activity.

4

Thanks Priyanka
but filter data table wont work as its huge number of columns and i need dynamic
can i have an example of LINQ to select only required columns out of the so many ?

5

this worked Arivazhagan.

6

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