Start Free Trial

Alteryx Designer Desktop Discussions

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

Render tool with first 3 rows on all outputs

janety0127
7 - Meteor

Hi,

I need to output using the render tool "group data into separate reports" selected. My issue is that the headers are in the first 3 rows of the output and so when the render tool groups data into separate reports, I need the first 3 rows (or the field names and row 1 & row 2) to appear at the top of each output. How can I configure this?

 

Thank you in advance

2 REPLIES 2
AkimasaKajitani
17 - Castor
17 - Castor

Hi @janety0127 

 

What you want to do cannot be done with a simple tool setup.

You have to make a simple logic.

 

For example, this is sample input.

 

AkimasaKajitani_1-1612679351401.png

 

You have to insert the header before each groups.

 

AkimasaKajitani_2-1612679462391.png

 

After that, if you render the data, you can get what you want.

 

AkimasaKajitani_3-1612679543902.png

 

This is sample workflow.

AkimasaKajitani_0-1612679259401.png

 

 

janety0127
7 - Meteor

@AkimasaKajitani This is perfect. Thank you!

Labels
Top Solution Authors