Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add dynamic number of rows at current position based on cell content

AkisM
10 - Fireball

I have a table that looks something like this:

 

Number 1Number 2Number 3
254
355
GRAND TOTAL109

 

but I would like to leave an empty row before the row that contains "GRAND TOTAL", and also add another 2 rows after it, because my final table should ideally look like this:

 

Number 1Number 2Number 3
254
355
   
GRAND TOTAL109
   
EVEN GRANDER TOTAL2018

 

Don't mind the logic for the calculations. Numbers can be random. I'm interested in getting the table structure right. Thanks in advance

1 REPLY 1
afv2688
16 - Nebula
16 - Nebula

Hello @AkisM ,

 

I think the simplest way would be to add an empty row:

 

Untitled - Copy.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels