How to append values in loop

I will get few values in loop ,i need to append the value in single line

For example
Here is the value in DT
ID
23
44
55
I will get this in datatable
My out put should be 23;44;55

Hi @sruthesanju

Try this expression

Use add data row activity

{String.Join(";",dt.AsEnumerable.Select(Function(r) r(0).ToString))}

Regards
Gokul

Hi @sruthesanju ,

Could you try this?

String.Join(";",DT.AsEnumerable().Select(Function(s) s("ID").ToString))

Kind Regards,
Ashwin A.K

I need to get the datas in variable

depending on your needs

array/list

define a variable arrValues | Datatype: String( ) - a String Array
Assign activity
LHS: arrValues
RHS:

YourDataTableVar.AsEnumerable().Select(Function(x) x("ID").ToString.Trim).toArray

define a variable Values | Datatype: List(of String) - a String List
Assign activity
LHS: Values
RHS:

YourDataTableVar.AsEnumerable().Select(Function(x) x("ID").ToString.Trim).toList

A flat string:
Define Variable: strValues | Datatype: String
Assign activity
LHS: Values
RHS:

String.Join(";", YourDataTableVar.AsEnumerable().Select(Function(x) x("ID").ToString.Trim))

; is the delimeter character and also any others can be used

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