Below is a sample of the input data I am working with.
| Ind | MID | RptYear | StartDate | Source | Result | Output |
| 123 | 10023547 | 2022 | 2/4/2022 | A | | |
| 1234 | 10023547 | 2022 | 1/8/2022 | B | 7 | Keep |
| 8816946 | 10103825 | 2022 | 2/4/2022 | A | >7 | Keep |
| 87865152 | 829700098 | 2022 | 2/9/2022 | B | 6.5 | Keep |
| 54357461 | 1010398372 | 2022 | 1/19/2022 | A | | |
| 54357461 | 1010398372 | 2022 | 1/19/2022 | B | 6.9 | Keep |
Notice the Column labeled output is not part of the input data, but a notation of the desired output. I need to generate an alteryx workflow that will do the following:
1. When there are two rows of data with the same MID and different Sources, retain or keep only the row with lab results that are not null or empty.
2. When when the row dos not have both sources, retain the record by default.
How is this accomplished in Alteryx?
Does anyone have any examples they can provide?
Thank you in advance.
JavaGirl!
