Adding a cover sheet on a separate tab with Excel output

Hi all!

i was wondering if there was a way to add in a cover sheet of sorts to be appended to the output?

I am basically sending Excel and PDF invoices/bills to customers and I want to be able to add a tab at the beginning that includes basic things such as the date, customer, invoice total, and the due date.

Also, if there is a way to make it dynamic (such as it inputs the correct date, grabs the customer name from within the file, and the dollar amount too).

Can someone please tell me the feasibility of this?

Thanks!

Rob

Output

Best Practices

Preparation

Accepted answers

CharlieS

@RMotiwalla

I've put together the attached solution as one way to achieve the desired result. Here are a few notes on the process:

- Extracting the data from the first few rows used a lot of position-based processed. I might recommend having a separate Name:Value set for more consistent references. For Example A2 could be "Consolidated Invoice Number:" and B2 could be "1085527".

Excel NameValue Pairs.png

- Text(36) in my example shows how to reference dynamic text in the Report Text Tool. The variables can be inserted form the "Available Fields" function on that tool.

- To produce multiple sheets from the Render tool, the "Section Breaks" mean "Different Sheets". If you want to specify these sheet names, look at Layout(40) in my example and note the use of the grouping and the selection of "Section Name" field at the bottom.

Let me know if you have any other questions.

20180725-ExcelInvoice.yxmd

All comments

CharlieS

@RMotiwalla

These are all very feasible items to achieve with Alteryx Designer.. Additional named sheets can be added to Excels produced by Alteryx from either the Output tool or the Render tool. Which are you using to produce the Excel file?

To answer your question about the dynamic values, we need to know more about what the data input looks like. Could you provide an example workflow and/or sample data?

RMotiwalla

Hi CharlieS,

I am using the render tool to produce my output.

My workflow is huge and very convoluted, most of it was put together by someone with much more knowledge than I have.

Please see the screenshots, first is the original data, then the output (not much of a difference, but its a large workflow and if there is more than one invoice it totals those and puts them on a separate tab), and the cover which I hope the red items can be made dynamic.

Please let me know if there is any other information that would help!

Thanks so much!!!!

Rob

Original dataRe-totaled, tab named

Cover sheet. I would like the red items to be dynamic

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703