How can get the datatable value first column first row data

Help Studio
, ,
1

i have data table with with 4 rows and A B , C D i want to rerieve only column A data i dont want other data in log message

2

Hi @T_Y_Raju

columnAData = String.Join(",", dt.AsEnumerable().Select(Function(row) row.Field(Of String)("A")).ToArray())

Regards,

3

Hi @T_Y_Raju

Try this LINQ:

columnADataString = String.Join(", ", dt.AsEnumerable().Select(Function(row) row.Field(Of String)("A")))

Follow the below steps:

=> Read Range Workbook
Output → dt

=> Use the below sytnax in Assign:

columnADataString = String.Join(", ", dt.AsEnumerable().Select(Function(row) row.Field(Of String)("A")))

columnADataString is of DataTyps System.String

=> Use columnADataString variable to print it in Log Message.

Regards

4

ok let me check and try

1 Like