Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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