Forum Discussion

marenas's avatar
marenas
Contributor
2 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 this? Thanks in advance.

  • 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!

2 Replies

  • del's avatar
    del
    Contributor III

    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

      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!