Multi_Row Formula Help

[Kristie_Pires]

Hello there,

So, Table 1 is an example of how my actual data looks like. I am trying to get to table 2. 

So basically, if I have a line then I should bring the line due date. If I don't have a line but have a CC, then I should have the CC due date instead.

The order would be Line > CC > Loan > Mod.

I think the multi-row would be the best tool but unsure how to write the formula. 

Table 1:

Loan ID	Product	Due Date
1122	Loan	3/1/2024
1122	CC	4/2/2024
1122	Line	3/13/2024
1400	Mod	5/2/2024
1400	Loan	6/2/2024
1400	CC	8/3/2024
1900	Term	3/4/2024
1900	Mod	4/5/2024

Table 2:

Loan ID	Product	Due Date
1122	Line	3/13/2024
1400	CC	8/3/2024
1900	Term	3/4/2024

[Raj · Accepted solution]

Please find attached workflow 
this is built dynamic so will work for more data as well

[AndrewDMerrill · Accepted solution]

Here is another workflow that functions similarly. It seems like your ordering doesn't account for the "Term" product although your output places it between "Loan" & "Mod", you can change the ranking input around as needed.

[Qiu · Accepted solution]

@Kristie_Pires 
We can prepare a mapping list for your products and their order in simple alphabet.

Then we can do sorting and Sample one item from each Load ID, that would be pretty easy.

[binuacs · Accepted solution]

@Kristie_Pires another approach

[Kristie_Pires]

Thank you all for providing multiple solutions to my problem! Truly appreciate you 😁

[Qiu]

Glad to help. 😁