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
Dt=DataTable.DefaultView.ToTable(false,"col1","col2","col3")
Regards
Arivu
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.
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.