Assign a repeating ID

[marenas]

Hi,

I have to incorporate a condition that – In the output, if ‘Name’ is the same, assign the same ‘Id,’ otherwise, increment ‘Id’ of the previous record. Can you please suggest how can I achieve this? Thanks in advance.

[del · Accepted solution]

For one way to do this with available snaps - please see attached sample pipeline:

Community.17134.slp (5.7 KB)

[del · Accepted solution]

For one way to do this with available snaps - please see attached sample pipeline:

Community.17134.slp (5.7 KB)

[marenas · Accepted solution]

Group by Fields and Sequence were in my head, but I couldn’t figure out how to transform the result. It makes sense to use the JSON Splitter.

Thank you for giving me the time to take a look at this post and provide a suggestion!