How to make value appear only once within the same group

Question

I have the following dataset and I am wondering how to make the pay value appear only once if the values in Name, Date and Number are the same? Thanks!

Example data:

NameDateNumberPayBob01/01/20211231000Bob01/01/20211231000Smith01/01/20215672000Smith02/02/20212453000Smith02/02/20212453000

Desired output:

NameDateNumberPayBob01/01/20211231000Bob01/01/2021123 Smith01/01/20215672000Smith02/02/20212453000Smith02/02/2021245

binu_acs · Answer

@overhead_press One way of dong this with the help of Multi-Row tool

Multi_Row_01_06.yxmd

Ladarthure · Answer

Hi @overhead_press ,

you can use the tile tool to identify the unique values and then use a if function based on the tile sequence num different from 1.

Find my workflow attached

tiling.yxmd