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.
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.
Hope this helps : )
_
Hi @jmwagner
Here is how you can do it.
Workflow:
Output:
Reference post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-tool-removing-double-spaces/td-p...
Hope this helps : )
I used this idea within a workflow that I needed to render to our Gallery with .pcxml. The replace using " " worked on desktop but didn't in the gallery. I found replacing with En Space (" " ) did work.
Thanks! DD