Can Alteryx append records to Excel tab at specific line number

[sonseeahray]

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?

[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.

[DiganP]

@sonseeahray Attached is an example.

Workflow:

[sonseeahray]

@DiganP. Thank you but I am unable to import the package and received this error message.

[DiganP]

@sonseeahray Wherever you saved the .yxzp file, there will be a folder with the workflow name. Please click on that folder and open the workflow. It should work fine. 

[sonseeahray]

Yes opening it directly from the folder worked.

I am sorry though that I still do not follow your suggestion. Do I need to create blank rows at the top of my output and then create a lookup for the position to join (#15)?

The attached file is a snapshot of the data I would like to append beginning at line 15 of the template I provided a screenshot of earlier.

[DiganP]

@sonseeahray yes you need to create a look up using the record Id tool for that position, very similar to the example workflow. 

[sonseeahray · Accepted solution]

@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.