Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Parsing Records with Pipe Delimited into New Columns

6 - Meteoroid

Good Morning,

I have a data set that came out of an ERP that looks like the below records..


Primary Identifier



I want the output to look like this


Store         City Code               ZipCode           Time of Transaction

0047           4877                       96027                2015-11-25


4 Different columns is what I need the output to be in.


Any help would be appreciated!

Alteryx Partner

@NRD - check out the Text to Columns tool!