In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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
19 - Altair
19 - Altair

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