Hello
I have some duplicate rows of data (IDs are duplicate only) which I want to apply some conditions for selecting one of the duplicate rows. F,or example in ID 1234 if Task A is null in one row and in the other row has a date, then keep the row with null. If Task A in both rows have date, then only keep the max date. Can anyone help me how to figure this out in easy morph? I know the keep max option. but for the other condition I need more help.
Thanks
Hi Sepehr and welcome to the Community!
I’m not sure I understand your question correctly. Can you please post sample data or a screenshot to clarify your question?
Thank you. below is my data:
I want to have the result as below:
I need to apply both Keep min/Max and something like Keep null in duplicated rows. meaning that for the duplications with one cell as null the other one with date, keep the null, and for those rows with date in both rows, keep the max.
Thank you for the example. The question is clear now.
In this case, I would split the table into two derived tables - one with IDs that have null dates, and the other with IDs that don’t have null dates. Then filter each derived table accordingly and append the results back into one table.
See the below project.
complex-dedupe.morph (5.9 KB)
Thank u so much. can you tell me the name of the actions you used. I cant use the newer version of easy morph. so the attached file doesnt work for me
would it be possible to have this attached file in the previous version of Easy Morph?
Thanks
