Table Tool duplicating the header for each record

[CDIns]

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, 

[Raj]

@CDIns 
will you be able to add workflow with sample data
will be in better position to help.

[CDIns]

Hi @Raj, thank you for getting back to me. Please see attached. 

[CDIns]

@Raj  is it because at the top of the table configuration, i have group by and every column selected? Should everything be unselected here? 

[apathetichell]

@CDIns when you use group by in a table tool you are effectively making a new table for each group. new table means new header. 

[CDIns]

Thanks for confirming, @apathetichell. One more quick question, Is there anyway to change the row background format? It defaults to alternating between white and gray background fill, however, I'd like to set the rows to 'No Fill', similar to excel. Is there a way to configure this? 

[apathetichell]

"alternate color" in table settings. set that to the same as the main color and that should work.

[CDIns]

@apathetichell That just fills every row white instead of no fill. Would I need to export to a formatted template instead? Ugh. Cant seem to win with Alteryx. 

[Raj]

@CDIns 
find the workflow attached
hope this is what you are looking for.

[apathetichell]

@CDIns - can I go with maybe? If you look at the css/html underlying your table you'll find rows like:

.dbf401f9bdefc4b0989cc5c2f566af51a tr.evenRow { background-color:#ffffff; }
.dbf401f9bdefc4b0989cc5c2f566af51a tr.oddRow { background-color:#f0f0f0; }
.dbf401f9bdefc4b0989cc5c2f566af51a thead tr { background-color:#dbdbdb; }

I'm not a CSS expert but this is what you'd need to edit.