How to move column heading row down in excel output

Hello; I need to add heading lines to my excel output. I am able to union together the two files however, my column headings appear in row one, then the 3 heading lines, and then my data. Any thoughts on the easiest method to move my column headings to the row after the heading lines? Seems very simple but sometimes simple things can be complicated. Any thoughts are appreciated. Thanks. Best regards Baryon

Input

Accepted answers

OllieClarke

Hi @Russell_Jones you can do this if you use a layout tool before your render tool

I've got 2 similar tables which I want to output to their own sheets. The name of the sheet is given by the [Tab] field, and the tables were grouped by this field in the table tool.

The trick is to put a layout tool set up like this: (layout each group of records (with your group ticked), Vertical with Section Break orientation, and your grouping field selected in the bottom drop-down)

This will create a sheet for each record that you've grouped by

Hope that helps,

Ollie

output sheets.yxmd

OllieClarke

Hi @Russell_Jones, you didn't include the data when you sent the workflow, so I can't run it. However, looking at it and making a couple of assumptions I'd say you want to do something like this (i've done it for 2 of the tables for the sake of the screenshot) :

Instead of outputting to the render tools, (assuming there is only 1 row of data going into the render tools), then use a formula tool to add the sheet name as a field to each table.
Then union all the tables together, and use the layout tool as before (grouping by the sheet name). Now you can output them all to one excel, but multiple sheets

Hope that helps,

Ollie

2020 risk assessment Phase 3 fresh.yxmd

All comments

echuong1

Can you post example files/an example of the output you're trying to achieve?

I assume you can just use multiple inputs and unions by record position or the reporting tools to achieve this. See the below link for an example using reporting tools:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-create-headers-in-Excel-report/td-p/346946

Russell_Jones

Yeah, of course.

This is how the output appears;

Location

Total Risk

My Company name Internal Audit

Predictive Risk Analysis - September, 2019

Demand Planning Controls

My Company France S.A.S.

10.00

And below is what I am trying to accomplish.

My Company name Internal Audit

Predictive Risk Analysis - September, 2019

Demand Planning Controls

Location

Total Risk

My Company France S.A.S.

10.00

Seems like it should be really easy.
Just trying to move the column headings (row 1) down 4 rows.
I'm writing to an excel file.
Hope this helps and thank you for your help.

Kind regards,

Russell Jones

Business Office USA 216-383-4842
Business Cell USA 216-213-2042

--------------------------------------------------------------------------------------------------------------------------------------------
*************************************************************
Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you, The Lincoln Electric Company
**************************************************************

echuong1

You can isolate each section using select tools and then union them back together. For the union, you can specify the order so the headers are moved down. See attached for an example. Let me know if that works!

New Workflow1.yxmd

Russell_Jones

Okay, I got the order right but I'm still getting the column headings appearing as the first line of the excel output. Is there a way to output to excel w/o picking up the column headings? It seems like alteryx at times does not play nice with excel. Perhaps another file format is the answer.

echuong1

Are you able to post a sample of the data you're working with? This would help in coming up with a solution that works.

I'm thinking you may need to use the reporting tools to add a "header" within excel. See the below thread for an example:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-create-headers-in-Excel-report/td-p/346946

Russell_Jones

Sorry for not getting back to you sooner.

I used your suggestion of using a reporting tool and it seems to work, thank you.

However I have another question or challenge.

When I send my output to the render tool, I have to output to separate excel files.

I need one excel file with multiple tabs.

Is there a wat to accomplish with the render tool?

Kind regards.

OllieClarke

Hi @Russell_Jones you can do this if you use a layout tool before your render tool

I've got 2 similar tables which I want to output to their own sheets. The name of the sheet is given by the [Tab] field, and the tables were grouped by this field in the table tool.

This will create a sheet for each record that you've grouped by

Hope that helps,

Ollie

output sheets.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335