Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Handle the Pipe Symbol (|) on Input Files

sblank56
5 - Atom

Hi,

 

I apologize for the simplicity of this question (new user), but would anyone know offhand how I could handle an input file (.csv) that uses pipe symbols to separate columns?

 

For example:

 

Portfolio|Security|Price|Quantity|Market Value

 

I'd like to be able to select each column separately but haven't much success using the 'Data Cleansing' option.  Unfortunately the file I'm working with is pretty massive and I'm unable to open in Excel.  I suppose I could probably do a find and replace in Notepad but am curious if there's a way I could do this directly in Alteryx without having to manipulate the input file beforehand.

 

Thank you for any help in advance, I appreciate it!


Regards,

Steve

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus
Have you tried using the input tool with a csv format and changing the delimiter from a comma to a pipe symbol?
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
sblank56
5 - Atom

Ha- that did it... figured it'd be something simple like that- thanks!

MarqueeCrew
20 - Arcturus
20 - Arcturus
Isn't Alteryx wonderful?👏
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels