Hiding Column Headers

[Asimkz157]

Hello all, fairly new to Alteryx here and still learning all the tools I have at my disposable. 

I have a requirement where I need to output a report without column headers.  In my report I have [Employee ID], [Employee Name] and different measures across different months.  The excel report should only contain the Employee ID and Name as the headers.  

So far I have tried using dynamic rename and selecting 'Take Field Names from First Row of Data' option in the rename mode but I'm getting a bunch of new column names.  The output is a basic table tool then render to send all the reports to a specific folder. 

What am I doing wrong in the dynamic rename?  I don't want the Field_25 etc. etc. including screenshot of my workflow .

[atcodedog05]

Hi @Asimkz157 

Did you try turning off headers in table tool. Refer highlighted below.

Hope this helps : )

[Asimkz157]

Yes, I tried that but the output will leave out the employee ID and name and I need to keep those for the report to make sense.  

[atcodedog05]

Hi @Asimkz157 

Can you provide sample data with column names and expected output. We can take a look into it.

[Asimkz157]

Attaching a sample workflow.  I included the desired output in a "text input" tool.  Thank you.  

[atcodedog05 · Accepted solution]

Hi @Asimkz157 

This what you can do.

Workflow:

Hope this helps : )

[Asimkz157]

Thank you so much.  That worked perfectly. 

[atcodedog05]

Happy to help : ) @Asimkz157 

Cheers and have a nice day!