topic Re: Keep the value only of first row per each unique name in Alteryx Designer Desktop Discussions

Keep the value only of first row per each unique name

Slawson5 — Sun, 26 Jun 2022 13:18:16 GMT

Hello,

I would like to duplicate the first value down per each unique name.

This is my current data -

Then I would like the output to be -

I'm trying multi row formula but can't quite get there (I'm new to this!) so would appreciate the help!

Thanks

Sarah

Luke_C — Sun, 26 Jun 2022 13:48:29 GMT

Here's 3 ways:

Multi-row: Use an if statement to check if the name is equal to the previous row's name
Sample: Take the first row for each Name, then join back to the dataset
Summarize: Take the first row for each Name, then join back to the dataset

Slawson5 — Tue, 05 Jul 2022 09:12:06 GMT

That’s great - just what I needed. Thank you!