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 recently updated to version 2018.2. When using an Input tool and selecting Full Path for Output File Name as Filed the full file path now has three pipes between the file name and tab name. It looks like this: C:\AlteryxFiles\test.xlsx|||`Tab A$`
Is this now the standard for Alteryx? I wanted to double check that it is not a bug on my end. This is affecting some of my modules as I used the | as a delimiter to breakout the tab name. I now have to trim off the two excess pipes.
I'm not going to be able to speak completely to Alteryx's motivation for the triple pipe, but I think at least part of it was related to issues reading in values inside of connection strings which contained valid pipe characters. In the past, any Pipe would be read as a delimiter for Alteryx, causing some connections to be non-functional.
Delimiting via a triple pipe significantly mitigates the potential for valid connection strings to include the character, allowing for better functionality in these edge cases.