Adding a row at the top in Table

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.

Desired outcome .xlsx

Workflow

Settings

Output

Tips and Tricks

Apps

Preparation

Accepted answers

apathetichell

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?lightbox-message-images-772451=188870i4EDC578FB48B9C7D

multi tables.yxmd

All comments

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,

row from header.yxmd

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

see attached.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-272-Configure-It-Out/td-p/772160/page/2?lightbox-message-images-772451=188870i4EDC578FB48B9C7D

multi tables.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335