Can Alteryx append records to Excel tab at specific line number

Can Alteryx append records to Excel tab at specific line number?

I have an Excel template that contains formulas in a header portion of a tab. These formulas provide summary information of the appended data.

For example, the summary information ends at line 14, and I need to append my Alteryx output at line 15. Is there a way to do this?

Output

Accepted answers

sonseeahray

@DiganP. Thank you for all your examples. I have decided to go with adding a temporary header row to my template which will allow me to simply use the 'Append To Existing Sheet' option for my output. It's an alternative that works just fine.

All comments

DiganP

@sonseeahray You can create a recordID column for the data you want to append and use the join tool to 'join based on recordID' (join by specific fields) to line 15. You can use the formula tool to create this record Id column.

sonseeahray

Thanks for your response. I'm not sure I follow you though, and maybe an image may help. This is a snapshot of my template where I want to have the Alteryx output begin at line 15.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703