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.
Hi,
Apologize it was a Mistake on the Output screen shot.
I've attached 4 attachments now.
Workflow1
Workflow 1 - Output
and
Workflow2
Revised Output
Workflow1 & Workflow 1 - Output - was my initial requirement and we managed to get that working see the attached.
Workflow2-
In this workflow I've amended the Table 1 to Include the Dates for you to help and I've also included the Revised output screenshot and this is what the final output should look like.
Also one more thing to mention here is that in your earlier solution you used Date time tool to convert that from string to Date which is fair enough but in my actual data set its already a Date Data type and is there a way to get this working using the Append Field tool.
Hope this is clear now. Apologize again.
