When working with multiple record, how to I return one value in a particular field

[fmitchell50]

Hello,  I am requesting some help on this please. 

The file attached will show what I am trying to achieve.

You will see two records have the same Policy Number but different Types.

For the Face Amount column, I want it to return one value in column G for either type. What's the best way to do this in Alteryx? In other words, the 3,500,000 should only show one time in column G. 

Thanks in advance for any input! 

[gawa · Accepted solution]

hi @fmitchell50 

Multi Row Formula tool would help. Specify group by "PoliceNumber" in configuration of Multi Row Formula tool, and write expression so only if the record is at top of that group, show FaceAmount(else NULL).

Refer to the attached WF.

[fmitchell50]

Thank you!! Works perfectly!! 😊