I am trying to select the first 25 rows in a specific column in a data table to be used as input for a Type Into field. How can I get just the first 25 rows from the data table as a string?

as mentioned it will return an array of string. Just do following: Assign activity Left: arrValues | Datatype: String( ) - string array Right side: YourDataTableVar.AsEnumerable.Take(25).Select(Function (x) x("Vendor").toString.Trim).toArray Assign activity: strValues = String.Join(“|”, arrVa…

Select first 25 rows in a datatable

Help Studio

ppr (Peter Preuss) June 2, 2022, 1:38pm 5

YourDataTableVar.AsEnumerable.Take(25).Select(Function (x) x("Vendor").toString.Trim).toArray

For LINQ starting have a look here:

Topic		Replies	Views
Select first 25 UNIQUE rows in a datatable Studio studio , question , activities_panel	6	611	June 11, 2022
Linq to Select first few columns using index in datatable Studio datatable , excel , selector , database , uiautomation , mail , robot , activities , studio , studiox , question , activities_panel , linq , linq-query , linq-quey	6	3235	September 22, 2022
How to get all values of data column in a datat table Help	10	2663	January 17, 2019
How to convert data table row values into array? Activities excel , activities , question	42	4452	October 16, 2022
Need help/advice in resolving a select from datatable Studio studio , question , properties_panel	4	1363	February 10, 2022

Select first 25 rows in a datatable

Related topics