Hello Community, I need some help with formatting. Right now my data is coming out fine but I would like bold certain text on the file. On the attached i have my original output and what i would like to see. This is my original data: AREMonthSymbolic AccountAccount NumberGL TotalTotal AccrualTotal BiWeekly AmountsUPD%Accrual CalculationVariance% Differences476T06T003 1021.270.510.635-0.635 476T06T002 1348727316.440.513658.22-171.22 476T06B001 174798353891.260.5176945.63-2147.63 476T 47118000-188295 476T Total -188295188295381228.97 190614.485-2319.4850.01 I would like for it to look like this: AREMonthSymbolic AccountAccount NumberGL TotalTotal AccrualTotal BiWeekly AmountsUPD%Accrual CalculationVariance% Differences476T06T003 1021.270.510.635-0.635 476T06T002 1348727316.440.513658.22-171.22 476T06B001 174798353891.260.5176945.63-2147.63 476T 47118000-188295 476T Total -188295188295381228.97 190614.485-2319.4850.01 Original Data.png What i would like to see.png Bolding Header and Totals Line.xlsx

Formatting Output Bolding Total Lines and Header

Hello Community,

I need some help with formatting. Right now my data is coming out fine but I would like bold certain text on the file.

On the attached i have my original output and what i would like to see.

This is my original data:

ARE	Month	Symbolic Account	Account Number	GL Total	Total Accrual	Total BiWeekly Amounts	UPD%	Accrual Calculation	Variance	% Differences
476T	06	T003			10	21.27	0.5	10.635	-0.635
476T	06	T002			13487	27316.44	0.5	13658.22	-171.22
476T	06	B001			174798	353891.26	0.5	176945.63	-2147.63
476T			47118000	-188295
476T Total				-188295	188295	381228.97		190614.485	-2319.485	0.01

I would like for it to look like this:

ARE	Month	Symbolic Account	Account Number	GL Total	Total Accrual	Total BiWeekly Amounts	UPD%	Accrual Calculation	Variance	% Differences
476T	06	T003			10	21.27	0.5	10.635	-0.635
476T	06	T002			13487	27316.44	0.5	13658.22	-171.22
476T	06	B001			174798	353891.26	0.5	176945.63	-2147.63
476T			47118000	-188295
476T Total				-188295	188295	381228.97		190614.485	-2319.485	0.01

Original Data.png

What i would like to see.png

Bolding Header and Totals Line.xlsx

Transformation

Accepted answers

alexnajm

Table Tool | Alteryx Help

Note the ability to affect the headers formatting under the Default Table Settings. For the Total row, you can create a Row Rule that can look for when Contains([ARE],'Total') and then formatting as bold accordingly.

All comments

alexnajm

Sounds like you'll want to use the Table tool as a part of the Reporting tool palette!

alexnajm

Table Tool | Alteryx Help

alexnajm

Then you'd use the Render Tool to output!

CrystalC0203

Thank you @alexnajm that worked!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335