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
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.