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.
Solved! Go to Solution.
Answer = Yes, it now seems to be a standard. Why, no idea! Happened a couple of versions ago!
Ben
Thanks! It's a quick fix but seems to be an odd change.
Hello,
Worth pointing out that using one pipe will also still work. Not sure why its changed to 3 either.
Nick
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.