Formatting Column Headers
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would love to proved wrong too! Thanks I will definitely do that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Now that's seriously impressive @CharlieS!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CharlieS Wow this is superb!