We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Table Tool duplicating the header for each record

CDIns
8 - Asteroid

At the end of my workflow, before I output, I added a Table tool in order to format the headers of my output. 

 

I clicked "default Table Settings..." at the bottom, navigated to the 'Headers' tab and changed the background color and made the font bold. 

 

Then I added the render tool and export the dataset. When I open my excel file with the output, I now have a formatted header for each row in the dataset, I only need one headed at the top of the page. Did I configure something incorrectly? 

 

I also noticed that if I use the table tool to format and then connect that to 'output data' table, my formatting doesnt carry over to the export and it also creates an additional column in my output called 'table' with a bunch of gibberish - is best practice to always use the render tool to export after using the table tool to format? 

 

Thank you, 

11 REPLIES 11
CDIns
8 - Asteroid

@apathetichell thank you for the insight. I can take a crack at trying to update that code and report back. Where did you find that code at?  I appreciate the insight.

apathetichell
20 - Arcturus

way 1) attach a browse tool after your render tool. If you click on your table - it'll pop up as your table. That's no fun. click on the glasses. seperate the two results panes so you enlarge the weird (sometimes hidden) granular content results pane - this should now show you the code.

 

way 2) - attach an output data tool after you table. output to .csv. use \0 as a delimiter.

Labels
Top Solution Authors