Adding new column based on previous column

Can someone pls help me in this fast its urgent.
I have attached the input and the required output.
If there is repeating entries I wanted to take the latest date and populate in the new column against that particular ID.
If it is a single entry take the same date.

Sample Workflow.knwf (2.6 MB)

Here’s a sample workflow that shows how to do it. It is basically just using the Groupby node to get the maximum by group, then joining it back to the original table by the group column. There are a lot of ways to get there, but I consider this to be the easiest.


thanks for the help, much appreciate it

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.