Group matching rows together

Help Forum
1

Hi Great Dev, I want to group Texas together on this column, since they match, please how do I do that?image

2

in case of you want to remove the duplicates e.g use Remove Duplicates Rows Activity for the datatable

or was the question about summing up group values?

3

If the value is the same, I’ll need to merge the matching values together like image

4

we cannot identify a merge, could it be the case that you would like it to get sorted together (refering to your screenshot)?

Or just provide us the expected output datatable, so we can use it for working out a solution suggestion

5

Yea, sorted together in the column as shown with screenshot

6

give a try on Sort Data Table Activity

Or

Assign Activity
LeftSide: dtSorted
Right Side:

(From d in yourDataTableVar.AsEnumerable
Let ic = CInt("0" & d("Code").toString.Trim)
Let spv = d("SpotVenue").toString.Trim
Order by spv, ic
Select r=d).CopyToDataTable
1 Like
7

Sort data table activity didn’t give me what I want, so I am using the assign but it’s throwing end of statement expected

8

Please always show error details to us. Thanks

9

[

image
image774×191 6.62 KB

10

please show us the Hovertext from the Blue Validation Icon:
grafik

As statement was checked locally and passed the validation we would like to see it driven from your implementation

11

IMG_20210817_164352_2
IMG_20210817_164352_21920×960 155 KB

This is it ppr

12

correct the line part (first Line) your dMatch

your datatable Variable has the name dMatch. the token your is unneeded and looks like a copy&paste issue / missining adoption task

13

Alright, I have corrected it

14

It worked, how about adding an empty row for each of the sorted group to separate them or make it distinct from the other rows.Any idea please

15

@RPA-botDev
Ideally we would avoid to modify the tabular data just for purpose to get a visual oriented (Group split by empty row) result.

From technical viewpoint we can do:

Assign Activity
LeftSide: dtRearranged | DataType: DataTable
Right Side:

(From d In yourDataTableVar.AsEnumerable
Group d By k1=d("SpotVenue").toString.Trim, k2=d("Code").toString.Trim Into grp=Group
Let nr = yourDataTableVar.NewRow
Let grpe = grp.Append(nr)
Select x = grpe).SelectMany(Function (x) x).CopyToDataTable

find starter help here:
GroupBy_2Col_GRPSeperator_InsertEmptyRow.xaml (7.3 KB)

1 Like
16

Thanks ppr

17

May we ask you to do your final testing and close the topic by marking the solving post as solution or just let us know your further open questions. Other can benefit from it. Thanks

1 Like
18

Alright ppr, I have marked as solution, if there is further, I’ll open another discussion and let you know.Thanks

19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.