The Table tool from the Reporting tab is removing double spaces

I have created a workflow that puts together a table which then gets exported to excel per a certain group. There is one field in that table which contains folder paths. We have an instance where the folder path has a double space in it. When creating the output I want the folder paths to be untouched. When processing it through the Table tool it removes double spaces. Is there a setting that is causing this or is this a default procedure with the Table tool?

Thanks in advance.

Reporting

Accepted answers

All comments

atcodedog05

Hi @jmwagner

Reporting tools using html logic at back end hence all double spaces and line breaks are removed. Follow the below post to insert the double space as required.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-the-Table-gt-Email-tools/m-p/129514#M20961

Hope this helps : )

atcodedog05

apathetichell

@RHehlmann I wouldn't recommend using Render here --- use an excel template and write data to that template sheet ---- and keep existing formatting.

RHehlmann

@apathetichell that is unfortunately not an option. I use my outputs for a variety of clients and it's only the data for that one client where there are embedded double white spaces. Also, there are some dynamic elements in the outputs that make using templates not feasible.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703