Null values in the following rows

Question

Hello All,

I am new to the Alteryx and need some help. I have a situation where few rows in the column named "Both" are populated with value 'U,B' for the same person ID. But, I need to create a new column where I want the first row to be 'U,B' and the following rows to be null for the same person.

Capture.PNG

jasperlch · Accepted Answer

@spandana16

Not sure if below is exactly what you would like to achieve:

You could achieve this by using a Mulit-Row Formula: