community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Text to Column Split

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
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.
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

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.
Quasar

You can use the select tool to rename the headers

 

Flow:

flow.PNG

 

Select:

select.PNG

Quasar

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

Meteoroid

Thanks mate, that's worked well.

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

Labels