Dears, I want to Concatenate Column Items into one String, as per the below example: Input : Column A item 1 item 2 … … item n Desired Output : output= “item 1”;“item 2”;“item 3”;…;“item n” Thanks in Advnace

Fine hope this expression would help you resolve this –hope we have the datatable ready with us and say named outdt str_output = String.Join(“;”,outdt.AsEnumerable().Select(Function(a) a.Field(of string)(“yourcolumnname”)).ToArray()) Cheers @hsendel

But the issue is the command is checking all rows, and I got this error message : [image] How to limit to only rows with data ?

but may i know what was the expression used and at which activity we are getting this error Cheers @hsendel

[image] Palaniyappan: String.Join(“;”,outdt.AsEnumerable().Select(Function(a) a.Field(of string)(“yourcolumnname”)).ToArray()) Thanks Palaniyappan . Problem Solved Here’s the command : String.Join(“;”,dt_Sample1.AsEnumerable().Select(Function(a) a.Field(Of String)(“Name”)).ToArray()) I have …

Fantastic thats what suggested i hope [image] hsendel: I have added command to count the number of rows with data and use another read range and start from A1 To A+NbRows.ToString and this was added new to this case no worries issue got resolved Cheers @hsendel

My target scope not achieved, because the aim of this , is to have an array to put it in “input dialogue” but it’s not working :crying_cat_face:

Fine what was the issue you were facing Cheers @hsendel

[image] hsendel: Input : Column A item 1 item 2 … … item n I want to have rows of one column as array in my “input dialogue”

[image] hsendel: String.Join(“;”,dt_Sample1.AsEnumerable().Select(Function(a) a.Field(Of String)(“Name”)).ToArray()) i hope that this expression would work what was the output that came up and what is the output actually required Cheers @hsendel

Concatenate Rows Items into one String

Help

hsendel September 11, 2019, 3:34pm 3

Thanks a lot I find similar subject : Convert 3 rows cell data to one cell data - #15 by sarathi125

Topic		Replies	Views
Concatenate row items to single string inside for each row Help datatable , excel , activities , string , question	2	2435	April 7, 2021
Concatenate rows into single string Help	13	15410	October 29, 2018
Concatenate n number of columns Activities datatable , excel , activities , studio , question	3	1239	March 5, 2022
Convert 3 rows cell data to one cell data Help	23	3120	December 12, 2022
Rows and .string method Help	2	3229	May 24, 2018

Concatenate Rows Items into one String

Related topics