Reporting Tools - replacing XML

[BS_THE_ANALYST]

Hi guys, 

I'm currently trying to force a specific font onto a table tool. I would like to solve this by updating the XML of the tool itself (I don't want to manually select the font). I know this can be achieved in a batch macro but I'm curious if this could just be achieved by using a formula tool or a known alternative.

Here's the issue I'm facing:

 

I haven't even touched the reporting element, simply copied it, and it's lost it's report object format (check the results window). The HTML remains the same under the hood though (if you look at the cell via cell viewer). Is there a way to bring it back to a table object?

I could be thinking of solving the issue incorrectly. Feedback is absolutely welcomed.

@danilang I know you've given some invaluable solutions, I'd love to hear your input on the matter.

Thanks guys.

All the best,

BS

[BS_THE_ANALYST]

Turns out you can just chuck it into a Report Text and configure it as follows. 

Interestingly, my Report Table object now has an alias as a Report Text. However, it's back into the reporting format:

 

Didn't know about this PCXML thing. Hail mary seemed to work.

Still, if anyone has ideas, please share them.

All the best,
BS

[CharlieS · Accepted solution]

@BS_THE_ANALYST you nailed it. Edit the PCXML text and re-inject using Report Text in Expert Mode. 

More info on PCXML:
Re: Specification PCXML - Page 2 - Alteryx Community

[BS_THE_ANALYST]

Thanks for the link @CharlieS. It's very much appreciated.

I was just clutching at straws clicking on random things. Your explanation on that link is awesome.

There's definitely a lot more experimenting to do on my side now. I wonder what else we can create with this? It's certainly sparked my curiosity. I haven't ever written anything in html/xml/pcxml before. I wonder if we could create something that's not in the reporting tool palette and bring it in.

I'll certainly feedback if I find any hidden gems.

All the best,

BS

[CharlieS]

PCXML is only found in Alteryx these days and even in this universe it's still a niche subject. 

It all starts like this: copy/edit/paste code development can still do a lot of cool things. Keep it up and share what you figure out!