Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Splitting of address into multiple columns

kafka_u21
7 - Meteor

I have an address column which includes Address, city, state & zip all combined into single column as example below. I needed it to be split into multiple columns, one column each for Address, City, State, Zip. #Designer #new2Alteryx #helpneeded

 

1070 PARK AVE APT 11A,NEW YORK NY 10211,,
8061 PEACHTREE ROAD, N.W.,SUITE 101,ATLANTA GA 60321,
100 SOUTH POINTE BEACH, APT.205,MIAMI BEACH FL 33141,
1141 5TH AVE APT 2B,NEW YORK NY 10211,
1 REPLY 1
alexnajm
17 - Castor
17 - Castor
Labels