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!
SOLVED

Text to Column Split

Highlighted
6 - Meteoroid

I am having issues using Text to Column in order to split consecutive digits into two columns to ultimately run a chart of accounts. Is there also a way I can assign these fields a title (I.E. 11 = Current Asset, 12 = Non-Current Asset etc)

 

From

 

Field 1
110002
111003
123003
124001
210011
221003

 

 

To

 

Field 1Field 2
110002
111003
123003
124001
210011
221003
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
How about....

Left([field],2)

And

Right([field],4)

As formulas for your two fields.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
6 - Meteoroid

Thanks Mark, that worked well! Love your work.

 

Any idea how to now assign a title to consecutive digits? I.E. 11 = Current Assets, 12 = Non-Current Assets etc

 

Cheers,

Tom

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
It depends on how many values that there are.

Switch([field],”Unknown”,’11’,’Current Assets’,’12’,’Non-Current Assets)

If there are many values you can use a Find and Replace Tool.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Find-Replace/ta-p/47042

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
12 - Quasar

You can use the select tool to rename the headers

 

Flow:

flow.PNG

 

Select:

select.PNG

Highlighted
12 - Quasar

Nevermind, misinterpreted the question. @MarqueeCrew is spot on with the switch.

Highlighted
6 - Meteoroid

Thanks mate, that's worked well.

Highlighted
5 - Atom

@JoshKushner Select Tool is what I was looking for, thanks!

Labels