OutPut in Desired Format

Question

Hi guys, i want to generate my output files in specific/desired format where by i don't have to keep opening the excel file and bolden the first row, change background colour to yellow and also have the all borders in the data.

Is there a way to to this in alteryx.

Attached are the excel files, one which is not formatted and the second with the desired output format.

Overdue as at .xlsx

Overdue as at  - desired Output.xlsx

atcodedog05 · Accepted Answer

Hi @mboroto_89

You can do this using reporting palate table tool.

Workflow:

Output:

Explore more on reporting palette here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%20in%20Designer

Hope this helps : )