Select first 25 rows in a datatable

Help Studio
, ,
1

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?

2

getting the first 25 rows - returned as a list (of DataRows)
YourDataTableVar.AsEnumerable.Take(25).toList

Getting the first 25 column values as an array
YourDataTableVar.AsEnumerable.Take(25).Select(Function (x) x(YourColNameOrIndex).toString.Trim).toArray

3

Hello @karen.c.stewart4.civ

Maybe you can do as below.

Dt2=Dt1.AsEnumerable().Take(25).CopyToDataTable()

Then use output datatable activity to convert to string.

4

When you say …(Function(x)… am I supposed to put the column name in there in place of the x? So for me the column name is Vendor. So would I do (Function(“Vendor”)…?

5

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

For LINQ starting have a look here:

6

When I do that it gives me an error - Value of type ‘1-dimensional array of String’ cannot be converted to String. Any thoughts on what I am doing wrong?

7

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(“|”, arrValues) it will flatten the array and seperate it with a pipe |

8

Thank you so much @ppr Peter! That worked great!!

9

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