community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Return the first 5 rows for each repeated name

Alteryx Partner

Hello, 

 

I have a list of Award names that repeated multiple times. Unfortunately the number of repeats vary for each award name and their corresponding ceremony. 

 

Does anyone know how to return the first 5 repeated award name for every award name irrespective of how many repeats there are? So, basically I would like to keep the stuff that are highlight in the image and discard the rest. 

 

Alteryx Help.PNGScreenshot of results workflow

It most likely is easy, but I have working on the whole workflow the entire and I cannot think of a solution. 

 

Thank you. 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Seffana 

 

It's pretty easy using the Tile Tool.

 

I overcomplicated a little bit to keep things organized and to generate duplicate values, but the key is to use the Tile Tool and then Filter the first five "Tile_Sequence_Num" of Unique Values.

 

WFSolution.PNG

 

WF Solution appended.

 

Cheers,

Alteryx Partner

Hey, Thableaus!

 

Thank you so much! It worked! That was so simple.

 

I have another (silly) question. 

Capture.PNG

 

Do you know how to fill rows in the reverse direction? As in get the string value in Record #15 [Award] to fill up the empty rows all the way to #1 and Record #27 [Award] to fill up the empty rows all the way up to #16 and so on?

 

I have tried multi-row formula but only know how to use it going in a downwards direction. 

 

Thank you and warm regards, 

 

Seffana

Labels