How to generate id for below scenario.

sgnarkhede2016

Hello,
I have input data that contain multiple customers with transaction and unqiue msgdb id 
I want data like

Cust  MSGDB_ID  ORDERNO
101    3                      1
101    4                      2
102    5                      1
102    6                      2
103    7                      1
104     8                     1
I want to generate ORDERNO column how can i do that? 

MartinLiebig

Hi,

Group Into Collection with Group by Cust and then Loop Collection and Generate ID inside.

Best,

Martin