All,
please find the sample flow and the expected output screen shot.
In the Expected Output I would to display the PRO Date column and a new New Colum called With Max Date grouped by ID column.
Hi @suby ,
I've changed your workflow a bit but you are getting the desired result now.
Let me know if you need further help.
Best,
Fernando Vizcaino
I'm attaching a solution to insert the max date in your dataset.
I'm not sure how to join the PCODE to your main dataset since you I'm not sure the exact rule to do it.
Hello
Thanks for sharing this.
The table 1 and table 2 is joined by ID column in my original workflow and the rule is to Pick the Max PCode for Each ID and sort that the New Field TEST by Descending.
You don't have to do anything you can use my existing flow but In the end I am looking for the expected output.
Much appreciate you response.
