I have a dataset that looks like the below:
NODE_KEY LOCATION_ID A B1D A B1E A B1F B B1G B B1H C B2D C B2C C B2D C B2E
How do I add a counter in a new field that is sequential for each NODE_KEY starting at '1'? Example below:
NODE_KEY LOCATION_ID COUNTER A B1D 1 A B1E 2 A B1F 3 B B1G 1 B B1H 2 C B2D 1 C B2C 2 C B2D 3 C B2E 4