We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding an Empty Row Between Data

Cfdiaz2103
8 - Asteroid

Hi Everyone!

 

I'd appreciate your help if you could help me to figure out how I could add an empty row between 2 rows of data

 

What I need is adding a empty row between the value "Total" (Field: Cliente) and the next value from the same column, as you can see in the attached file.

 

Thanks for your support.

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Cfdiaz2103 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1626881298549.png

 

1. Using multirow-formula tool to check whether the Cliente is total and its not the last row if yes flag as 1.

2. For every flag 1 generate an extra using gen row tool.

3. For every generated row change the Cliente & value column to blanks.

 

Hope this helps : )

Cfdiaz2103
8 - Asteroid

Hi @atcodedog05 !

 

I thought it would be more complex.

 

Thank you 🙂

Labels
Top Solution Authors