Merging rows using linq query?

[yashashwini2322 (Yash)]

Hi,

I have a datatable having 5 columns and multiple rows ,i need to merge all the rows from 3 Rd column ,one after the other.and also need the description after every cell.

Ex:

Row1
Issue statement: cell value
Issue summary: cellvalue

Row2
Issue statement: cell value
Issue summary: cellvalue

How can we do this using linq query?

[ppr (Peter Preuss)]

can you illustrate your case with some sample data? Thanks

[yashashwini2322 (Yash)]

Consider above image is an example

In this example I want the output to be merged as below

Str=
Issue id: b,summary:c,description:de,Party:e

Issue id: f,summary:g,description:h,Party:i

[ppr (Peter Preuss)]

have a look at these samples as a starter help:

We can adapt and also bring it within a Query Syntax

[yashashwini2322 (Yash)]

Can you send me the query

[ppr (Peter Preuss)]

Also have a look at this sample, done via a JSON Serialization:

Kindly note: Immediate Panel is decorating in some scenarios a " e.g. with “”

[ppr (Peter Preuss)]

 dtData.AsEnumerable.Select(Function (x) String.Join(",", arrColSet.select(Function (c) c &":" & x(c).ToString().Trim))).Aggregate(Function (x,y) x & vbCrLF & y )

JsonConvert.SerializeObject(dtData.DefaultView.ToTable(false, {"Column2","Column3"}), Newtonsoft.Json.Formatting.Indented)

[yashashwini2322 (Yash)]

Can you send me the xaml file

[ppr (Peter Preuss)]

was done within the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

we would move it to an assign acticity

arrColSet = new String{“Col1”,…}
strFlatten = THE_LINQ_CODE