Hi Alteryx Community - I'm trying to find a way how to get the first non-blank record for a records with the same key. I've put a before and after of what i'm looking for. Can someone please help? Thanks!
Before:
| Line of Business | ID | Type | Commitment | Utilized |
| Melissa | 123456 | House | $ 100,000 | |
| Melissa | 123456 | | | $ 55,000 |
| Melissa | 958754 | Condo | $ 200,000 | |
| Melissa | 958754 | | | $ 75,000 |
| Melissa | 156448 | Building | $800,000.00 | |
| Melissa | 156448 | | | $500,000.00 |
After:
| Line of Business | ID | Type | Commitment | Utilized |
| Melissa | 123456 | House | $ 100,000 | |
| Melissa | 123456 | House | | $ 55,000 |
| Melissa | 958754 | Condo | $ 200,000 | |
| Melissa | 958754 | Condo | | $ 75,000 |
| Melissa | 156448 | Building | $800,000.00 | |
| Melissa | 156448 | Building | | $500,000.00 |
