I have one table containing different entries for same IDs, like this:
and so on…
How can I append a suffix to the IDs to have a unique ID for each entry? Like in this example:
and so on…
I am trying with loops for extracting all entries per each ID but in the string manipulation I could not find any helpful function. Do you have any idea?
I would be immensely grateful!
Hi there @ChineS,
idea is following:
- Use Counter Generation node to add Counter column
- Follow that with Rank node where ranking column is Counter (ascending) and group column is ID column
- Finish it with String Manipulation where you use join() function to join ID column and Rank column with underscore between them.
If any questions/comments feel free to ask. Hope this idea helps!
thank you so much!
Firstly I discovered this super useful KNIME extension and, after converting also the Counter column to string, it worked! I am now executing the same in a loop grouping each and every ID.
glad to hear that. You are welcome
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.