Hello, I would like to ask on what is the best way to generate a key based on scenario below
Let's say I have 1000 records with ID of 01A, I want to group this into 199 items each. So it will be like
01A 1(199 times)
01A 2(199 times)
01A 3(199 times) etc.
how do we achieve this in BODS?