Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Parsing Records with Pipe Delimited into New Columns

Highlighted
8 - Asteroid

Good Morning,


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

 

Primary Identifier

0047|4877|96027|2015-11-25

 

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!

Highlighted
Alteryx Certified Partner

@NRD - check out the Text to Columns tool!

2.PNG

Labels