I have this data table: Code,Hours 1,02:00:00 9,04:00:00 1,06:00:00 9,03:00:00 2,02:00:00 I want to Group By Code, and Sum on Hours, resulting in a data table something like this: Code,SumH 1,08:00:00 9,07:00:00 2,02:00:00 With a SQL DBMS approach, this would be easy as pie, but perhaps …

@Jakob_Petersen PFA demo implementation here: Jakob_Petersen.xaml (9.6 KB) [grafik] the solution makes use of timespan DataType for the hour/minute/second Addition the group by was realized by iterating over the different groups (first for each) and processing the group rows (second for each) …

Group by and sum possible with UIPath compared to using an external database solution?

Help

balupad14 (Balamurugan) December 15, 2019, 3:57pm 7

Hi @Jakob_Petersen,

Take a look . In the below one has an activity called “Group by aggregation”. It helps you…

Regards
Balamurugan.S

Topic		Replies	Views
Sum values group by columns Help excel	29	14912	May 11, 2020
Processing a datatable (multi-pronged challenge) Help datatable , activities , question	1	732	December 7, 2019
Group by in UiPath Help	6	6408	March 15, 2020
How to use group by and get sum? Activities excel , activities , question	8	4804	September 24, 2021
How to aggregate data in datatable using LINQ in uipath(Group by Operator) Tutorials activities , studio , question , faq , linq , other-products	0	1219	October 12, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Group by and sum possible with UIPath compared to using an external database solution?

Related Topics