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.
But I still didn't understand how to join by ID table 1 and 2.
For example, ID 72 has PCODE IC and IR and in your output you have only IR
But for ID 73, you have all 3 incidences from table 2. I need one more rule to be able to join the PCODE to the table 1, for instance, the date for each line of ID + PCODE.
