Basic tables to excel sheets

If in my workflow I have two tables - for example:

Veg	Count	Sheetname
Carrots	1	Veg
Potatoes	3	Veg

Fruits	Count	Sheetname
Apples	2	Fruits
Pears	3	Fruits

My aim is to get one excel output with each table on their own sheet without the column 'Sheet name'. However that column is used to rename the sheet names to 'Veg' and 'Fruit', respectively.

Currently both tables are formatted in 'Basic Table'
I use 'Union' and then 'Layout' tool.

Layout mode: Each Group of Records

Group By: 'Sheetname'

Orientation: Vertical with Section Breaks

Section name: Sheetname

Using 'Render', this outputs one excel file, with two sheets named 'Veg' and 'Fruit', and the correct table on each sheet.

However, I have the column 'Sheetname' - how do I remove this from my output?

Is there a better way to rename my sheet names without bringing in this column so that it is not in the final output?

Output

Accepted answers

Gaurav_Dhama_

Not in the layout tool, inside basic table tool, you can create the table excluding the sheet name, group by sheet name so that same can be used in your layout tool.

Everything will remain same, just inside basic table tool, under column configuration uncheck sheet name. Have it checked in group by.

if that’s not clear I can post a snip of the flow in sometime.

All comments

Sudarshan08

Hello try this.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-change-the-name-of-the-output-file-sheet/td-p/985991

Gaurav_Dhama_

In your "Basic Table" tool, uncheck the Sheetname from column configuration, as shown below. That should fix it.

gflanagan

I have Layout Mode as 'Each Group of Records'
For me, this changes the view for 'Per Column Configuration' so that I do not have the option to unselect a specific column.

Gaurav_Dhama_

Not in the layout tool, inside basic table tool, you can create the table excluding the sheet name, group by sheet name so that same can be used in your layout tool.

Everything will remain same, just inside basic table tool, under column configuration uncheck sheet name. Have it checked in group by.

if that’s not clear I can post a snip of the flow in sometime.

gflanagan

Ah amazing - thank you that works now.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280