Populating Rows

[angelique_martin]

Hi Alteryx Community,

I am currently trying to figure out how to copy the same data down into multiple rows. Please see below what I have versus my desired result. Any help is greatly appreciated. Thanks!

Current Outcome:

Desired Outcome:

[Chantelb · Accepted solution]

Hi @angelique_martin 

You could use a summarize tool and use the max of Include MF/WR/CS and then join this back to the original data. See the workflow attached.

Let me know if this helps!

[raychase]

I would use a summarize tool, grouping by the RowID to get the MAX values for each of the 'Include' fields, then I'd join these results back to the original data set, on the RowID field.  Then I would de-select the original 'Include' fields, keeping those from the aggregate.

Example attached.

[Qiu]

@angelique_martin 
I tried a different approach. 😂

[angelique_martin]

Thank you all! Great solutions.