How to filter data table columns dynamically

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.

Hi @gsunilusa,
Try below query


Hi ,

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

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 ?

this worked Arivazhagan.

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