data manipulation question

Hi

I’m trying to create a new column called “Data ID” to add to my data as in the example below. It seems like I need to count the data for each name then do some string manipulation to modify the data in the ID column, but I couldn’t figure it out. Thanks.

Try this. There are probably simpler ways but I didn’t agonize much.


2 Likes

Hi @tnad,

this is my solution based on your example.

workflow
result

Example.knwf (8.3 KB)

BR

3 Likes