OutPut in Desired Format

[mboroto_89]

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.

[atcodedog05 · Accepted solution]

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%... 

Hope this helps : )

[mboroto_89]

Thanks @atcodedog05 this is great, also, after formatting can i be able to generate output with today's date? such that it the final file is both formated and also has today's date at the end for instance Overdue as at 17.08.2021