Forum

Partition or Split ...
 
Notifications
Clear all

Partition or Split a Large Table by first N, Second N

2 Posts
2 Users
0 Reactions
142 Views
(@raffrobb)
Posts: 38
Trusted Member
Topic starter
 

Hi All:

I have a table with 5 million rows that I want to partition into groups or datasets.

Is there a way to group first 500,000, then second 500,000 etc.

I used the modulo, which is a decent hack but  it groups by index number rather than consecutive groups.

 

Thanks

Robb

 
Posted : 15/02/2021 12:26 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Robb,

Have you see this tutorial on numbering grouped data in Power Query?

Mynda

 
Posted : 15/02/2021 6:56 am
Share: