Forum Discussion

marenas's avatar
marenas
Contributor
3 years ago
Solved

Assign a repeating ID

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 t...
  • del's avatar
    del
    3 years ago

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

    Community.17134.slp (5.7 KB)

  • marenas's avatar
    marenas
    3 years ago

    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!

del's avatar
del
Contributor III
3 years ago

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

Community.17134.slp (5.7 KB)

  • marenas's avatar
    marenas
    Contributor
    3 years ago

    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!