Unable to get the datatable and assign it to a variable

Help Activities
, , ,
1

Hi All Friends ,
I am not able to read or select the particular Data from Data table variable and assign it to a particular variable and print that data . please all friends help me on this problem. please find screenshot also for this issue.

Datatable read dat from variable
Datatable read dat from variable1920×1080 155 KB

2

Hi @varun_shinde ,

Would you be so kind as to let us know what exactly it is you are trying to achieve?
Do you simply want to retrieve an array of the elements in a given column, or do you want to splice the datatable into smaller datatables ?

Could you tell us what the desired outcome should look like?

If its Array of values → 

Filter.AsEnumerable().Select(Function(s) s(ColumnNameOrIndex).ToString).ToArray()

If its splicing → 

Filter.AsEnumerable().Select(Function(s) Res.Clone.LoadDataRow({s("Name"),s("Age"),s("Salary")},False)).CopyToDataTable()

This works, provided you initialize DataTable Res first with the required columns either by using the Add DataColumn Activity or the Build DataTable Activity.

Kind Regards,
Ashwin A.K

1 Like
3

Hi Ashwin yes i want to retrieve an array of elements from Data table variable.

4

Hi @varun_shinde ,

Then this ought to help you out:

Filter.AsEnumerable().Select(Function(s) s("Name").ToString).ToArray()
Filter.AsEnumerable().Select(Function(s) s("Age").ToString).ToArray()
Filter.AsEnumerable().Select(Function(s) s("Salary").ToString).ToArray()

Or even

Filter.AsEnumerable().Select(Function(s) String.Format("{0},{1},{2}",s("Name").ToString,s("Age").ToString,s("Salary").ToString)).ToArray()

Kind Regards,
Ashwin A.K

5

HI @varun_shinde

Method 1
You can try with For each Row in DataTable Activity

Use Assign Activity

LHS → Create an variable
RHS → CurrentRow(“ColumnName”).Tostring

Method 2

Use Assign Activity

LHS → Create an variable
RHS → Dt.Rows.Item(0)(0)

(0) → Indicate Row
(0) → Indicate column

Regards
Gokul