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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Enter rows after certain fields

Meteoroid
Hi all, I have the following data set: Name Quantity Apples 1 Oranges 2 Kiwis 3 Bananas 4 Potatoes 5 Tomatoes 6 Chicken 7 I want to insert new rows only after Bananas and Tomatoes, label them as total fruits and total vegetables and then makes those rows to summarise the relevant data Name Quantity Apples 1 Oranges 2 Kiwis 3 Bananas 4 Total fruits 10 Potatoes 5 Tomatoes 6 Total vegetables 11 Chicken 7 Any clever ones out there that can help?
Alteryx
Alteryx

Hi @Emanuelis 

 

I have created a group lookup up and then used that to create the totals. I had to prefix the "Total" with "Zzzzz" to make sure it always come last.

 

Workflow.jpg

Highlighted
Aurora

Hi @Emanuelis 

 

Here's a slightly different way, similar to the solution by @JoeS but it retains your original row ordering

 

WF.png

 

The trick is to use a record id and then set the record Id of the total row to be .5 more than the last item in the group

 

Results.png 

 

Dan

Alteryx
Alteryx

@danilang nice addition!

 

Going to re-use that now going forwards.

Labels