Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically Generating Blank Rows

akvsachin
8 - Asteroid

Comparing the input file, SampleBook, and Output File, Output-SampleBook.
I know how to summarize data, grouping, sub-totals and Grand-totals. I need to add a blank row after every grouped data just like in output file in alteryx.

WhatsApp Image 2025-01-27 at 16.47.37_22a87d06.jpg



I have marked rows with [RowCount]=1 to go blank, but maybe there's an expression error with Multi-Row Formula that the results are not going null.

3 REPLIES 3
akvsachin
8 - Asteroid

I checked it's working now.

 

Now, I need a blank row at the end, i.e. after grand total.

alexnajm
18 - Pollux
18 - Pollux

You can union in a blank row via a Text Input perhaps?

Gumsmenezes
10 - Fireball

Hey buddy, this gets the job done. Maybe you can get inspired and use parts of it on what you already have :)Screenshot 2025-01-27 155528.png

Labels
Top Solution Authors