Formatting Column Headers

[amcghee6]

So my group is very big on formatting and the way things look. I was wondering if there was a work around in Alteryx to where the letters before the column titles could be either bold, colored red, or both? 

[Jonathan-Sherman]

I'm not aware you can colour / bold or format "part" of a column header, but would love to be proved wrong! If it's not available you could add an ideas to the forum at https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas

[amcghee6]

I would love to proved wrong too! Thanks I will definitely do that. 

[CharlieS · Accepted solution]

This is possible, but it's messy and won't work with any characters/conditions.

What we need to do is start out by creating the original Table (which is created as a Layout field), then editing the raw PCXML text of that Layout field with a formula tool, and recomposing that raw PCXML as a Layout field (using a Text tool in Expert mode) before rendering the final output. 

When you look at the raw PCXML text, you'll see that it generally following HTML formatting conventions. To bold a section of text, we need to wrap the "<b>" and "</b>" markers around the text we want to bold. In this case, this is conveniently marked by parenthesis (which also don't appear elsewhere in the PCXML), so we can replace "(" with "<b>(" to bold the parenthesis and everything between them, or "(<b>" to exclude the parenthesis from the bold format. 

Check out the attached workflow to see this in action and let me know if you have any questions. 

[Jonathan-Sherman]

Now that's seriously impressive @CharlieS!

[KimLamNg]

@CharlieS Wow this is superb!