Counting Generation by each group

Hi,

I would like to generate counting number by group of customer ID as follow;

Customer ID Counting number
AAA 1
AAA 2
AAA 3
BBB 1
BBB 2
CCC 1

I am not familiar with loop. I don’t know which nodes should I use.
Any recommendation to make this work?

Thank you for supporting.

1 Like

Hi @kpornbut

You can achieve this without a loop. Double the CustomerID column and use a Rank node (mode = ordinal). counting_customer_id.knwf (17.6 KB)
image
gr. Hans

4 Likes

@HansS Thank you so much ! :smiley:

1 Like

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