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

Highlighted
6 - Meteoroid

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 Partner

@NRD - check out the Text to Columns tool!

2.PNG

Labels