Adding a row at the top in Table

[mjh418]

Hi all,

I would like to know if it is possible to manually add a row in the TABLE TOOL(under Reporting Tools). 

If it is impossible within the TABLE tool, any workaround before using the table tool(such as using a manual input and somehow appending it above the top row) would still be helpful. I have a feeling merging cells would be difficult..I would still be happy to take if the outcome table LOOKS like its merged although it isnt. 

Please refer below for current status and the attachment for expected/desired outcome.

Date	Variety	Type	Value	Value2
Jan 2020	XX	A	7	3
Feb 2020	XX	B	1	6

Thank you so much for your time.

[mceleavey]

Hi @mjh418 ,

This is an interesting one because it depends on how your data is formatted to begin with. Hopefully from my example it will show you how it's done to make it dynamic.

I've basically used a transpose tool to pull the headers into a column and pivoted back to get the data in a row. I've then used record positioning in a union tool to align everything to the new headers:

Which gives the following output:

Hope this helps,

M.

[HomesickSurfer]

Hi @mjh418 

Would you consider appending your output records/rows to an .xlsx template that has the Category (B1:C1) and Values (D1:E1) headers as well as your subheaders in Row2?

[apathetichell · Accepted solution]

Where is your second row data coming from? is it from an interface or another part of the workflow? If it's an interface it's probably easier to add it prior to via a union tool, if it's from another part of your workflow, perhaps you can you can add it as a second table which you then add to the first table. make sure borders are off on the first set of tables. The table within a table solution was actually one way to solve this week's weekly challenge.

see attached.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-272-Configure-It-Out/td-p/772160/page/2?...

[mjh418]

@mceleavey   Thank you again for your time!

Unfortunately this won't work when using the Table app. I  need that top row merged to represent multiple bottom columns as a single column. The below solution using multiple tables may work although it doesn't look pretty at all.

[mjh418]

@apathetichell    This is probably the only solution closest to what i'm trying to achieve in Table app.. do you know if the row width/font/background colors are adjustable for the "boxes" or "row" of Category and Values? The Height of the row is too tall, the background color needs to be other than White, etc..

[HomesickSurfer]

Hi @mjh418 This is why i recommended appending your output records/rows to an .xlsx template. You have full control of the output cell/column/row formatting.

[apathetichell]

Most of the table options are customizable including background color and "alternative background colors"... I believe font size controls the height but you can also include padding. Here's the background color control. Just remember to do it for the all of the tables that should reflect those options.