Insert Rows Above

I have a workflow that creates a worksheet that is given to people to fill out. When I would create this manually I would insert the instructions in the first 4 rows above the header of the worksheet. Is there a way I can get Alteryx to do this for me? I included an example of what I am trying to have alteryx do below.

CPS Instructions.xlsx

Tips and Tricks

Accepted answers

IraWatt

Hey @tgilbert,

Probably the cleanest way to do this is with the reporting tools:

You can add your text at the top then union it followed by a layout to get one on top of the other. The render tool will let you output to excel.

Any questions or issues please ask
HTH!
Ira

Example 2705.yxmd

All comments

IraWatt

Hey @tgilbert,

Probably the cleanest way to do this is with the reporting tools:

You can add your text at the top then union it followed by a layout to get one on top of the other. The render tool will let you output to excel.

Any questions or issues please ask
HTH!
Ira

Example 2705.yxmd

tgilbert

This is awesome! The only issue I am running into now is in the layout. It is showing Text as being above the Table, but when running it the text goes all the way to the bottom under my data. Any ideas on what may be happening?

IraWatt

Nice one @tgilbert ! no worries glad you got it sorted

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703