We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parsing the data

Kavya432
8 - Asteroid

Hi Team,

 

I have data needs to be parsed as First and Last names. If it has like 3 spaces I am unable to parse those. They should come under Last name column.

 

Kavya432_1-1583192396611.png

 

 

2 REPLIES 2
bpatel
Alteryx Alumni (Retired)

hi @Kavya432 ,

 

is this what you are looking for?

 

bpatel_0-1583192722429.png

 

fmvizcaino
17 - Castor
17 - Castor

Hi @Kavya432 ,

 

Attached is an example showing how to do it.

fmvizcaino_0-1583192846087.png

 

 

BEst,

Fernando Vizcaino

Labels
Top Solution Authors