This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm building a workflow that will create a memo with up to 100 boilerplate paragraphs taken from a text input tool. The paragraphs will be included or excluded based on an earlier section of the workflow, and a header with the relevant country will be attached to each paragraph.
My question is about formatting the country headers. This is how the report currently looks:
My goal is to have each of the headers bold and centered like Canada (1), but they are currently being output without any formatting like Colombia (2).
I'm using the report text tool's 'Available Fields' function to create the memo, and I'm currently formatting it like this:
Now that's good and fine, but I want to avoid having to manually format over 100 of these '_Header' fields because it will A.) be a huge time sink and B.) prevent on-the-fly formatting changes down the road if need be. What I'm looking for is a way to automate the formatting for these '_Header' fields either through an alteryx tool, HTML, or PCXML, or to at least make it a more efficient process.
I'm currently creating the line breaks for the paragraphs by converting HTML to PCXML, so I believe that is a possibility, but I just don't know what PCXML code I would use to bold and center the column headers. Please let me know if you have any experience with something like this, or have any thoughts. All ideas are welcome! I can upload a version of the workflow, but I will need to sanitize the input data first.
Thanks for the advice! I tried your solution and it definitely helped with formatting the headers! However, because I am using PCXML to code in the line breaks, the final output is a bit wonky. I've attached a sanitized version of the earlier workflow in case you have a moment to check it out.