Group by sum and add the grouped data to a new datatable

Help Forum
24

use immediate panel

Groups.Count - in your case: ListBuilddt.Count - Count of Groups
Groups.Average(Function (x) x.Count) - Avg of groups members

1 Like
25

List count - 246093, average - 1.0074931022012004

26

Hi ppr, please can you share a sample parallel for each you’ve tested that is working fine so I run it on mine system to know what’s wrong with mine as I am still stuck and haven’t moved with the solution.Regards

27

please provide me some sample data (at least 2 groups) to be more close to your case. Thanks

28

[quote=“ppr, post:4, topic:390230”]
TAKE A LOOK PLS

parallel_Process.zip (2.3 MB)

29

Second file loaded - parallel_Process2.zip (2.3 MB)

30

Hi Ppr, are you there, apologies I sent the wrong files yesterday, the right files to contains sensitive information but it doesn’t process for the solution. It has up to 11 headers

31

currently im looking on it.

32

there were some incorrect implementations within the XAML which I corrected.

I was upading the grouping / summation to TRNS, Sheet1 data
transaction.Rows.Count: 288999

  • Groups
  • Executed within less then 5 seconds for entire workflow

Find updated MAin here:
Main.xaml (11.1 KB)

2 Likes
33

Alright, I have downloaded will check and mark

34

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