Alteryx Designer Desktop Discussions

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

Add 20 Blank Rows in between each Union input

Alteryxexpert
7 - Meteor

I have a Union where 6 inputs are merged in it, I need to insert 10 empty rows below each union input and write the same into excel. is this possible in alteryx?

3 REPLIES 3
bgreedy
7 - Meteor

You could use a generate rows tool and then Union the empty rows onto each input before unioning everything together

csh8428
11 - Bolide

@Alteryxexpert  Try this. If it works please select as the solution and give a like

rzdodson
12 - Quasar

@Alteryxexpert assuming you have a categorical field that contains your inputs (think: team name, department, etc.), here is another way to think through this one.

 

Solution.png

Labels