Want to achieve formatting of table along with dynamic rename tool

[YashikaVaish]

Hi Everyone,

I am new to the Alteryx and got one task where I need to create a summary table . This summary table columns headers are dynamic and also it has some formatting like bold,highlighting and borders. I used dynamic rename tool to achieve dynamic header names but problem is when I am putting table tool after dynamic rename tool , Table tool is hard coding the value of headers. 

If I am putting table tool before dynamic rename tool so table formatting is not happening . Please let me know is there any way we can achieve dynamic headers along with formatting of table. If yes then how ?

I am attaching the screenshot of workflow and table tool configuration where it is making the columns static and the desired output with formatting and with dynamic header .

Please let me know whether is there any way to make table tool dynamic and achieve the formatting functionality along with dynamic rename tool.Many Thanks in advance , Any help is appreciated.

[CharlieS · Accepted solution]

Hi @YashikaVaish 

Yes this is possible. My suggestion is based on two key functionalities in the Reporting tools:

- Table tool: deselect the "Show Column Headings" checkbox. 

- Layout tool: "Vertical Merge Contents to line up Table Columns"

What we're going to do is create two tables without headers (but one of those tables IS the header values), then stacking them vertically so the output looks the same. You'll need to apply your dynamic renames beforehand, then the attached workflow show an example how this can be done. 

Check it out and let me know if you have any questions. 

[YashikaVaish]

Thank you so much for helping