Hi, I have a set of data that is structured as many rows in a single column within a data table that I need to concatenate into a single row, separated by a semicolon. What is the best way to do this in UiPath. Below is an example how the data is currently structure and how I need to re-structured: …

Thiis doesn’t work for you in Assign? Copy Paste string CommaRow=string.Join(“,”,dtOpenCases.AsEnumerable().[Select](Function(s) s.Field(Of String)(“nCaseID”)).ToArray()) [image] CommaROw.xaml (5.9 KB)

Concatenate rows into single string

Help

Ancher (Ancher) May 1, 2018, 12:47pm 6

Great example! Could you please help me extend it, so that output will come in quotes like “John”,“Jane”,“Albert”…etc.

Foreach loop output as array instead of string.join

Topic		Replies	Views
How to concate the string of rows with same id in datatable uipath? Help studio	4	1006	December 24, 2018
How can you concatenate the names of all employees into a single string separated by commas using LINQ in UiPath? Automation Ops studio , question	4	180	October 31, 2023
Concatenate Rows Items into one String Help	16	11637	September 14, 2019
Possible to read many rows and store it in one string variable? StudioX studiox , question	5	806	August 3, 2022
Read 3 column from an excel file, concatenate them as strings and write them into another app Help excel , uiautomation , activities , question , data_manipulation	5	2948	November 27, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

Concatenate rows into single string

Related Topics