How to append values in loop

[sruthesanju (Sweety)]

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

[Gokul001 (Gokul Balaji)]

Hi @sruthesanju

Try this expression

Use add data row activity

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

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Hi @sruthesanju ,

Could you try this?

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

Kind Regards,
Ashwin A.K

[sruthesanju (Sweety)]

I need to get the datas in variable

[ppr (Peter Preuss)]

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