The PIPE Delimiter (|) is not functional in any output scenario.
 
We recommend that you use the CSV Delimiter choice and replace the commas with pipes (in View SQL, in the Output screen).