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

Adding a new column based on Row data

Highlighted
Meteoroid

I want to go from the first screenshot to the second. Excel is attached below. Thank you.Capture.PNG
Capture2.PNG

Quasar

If the example data is exactly what you expect to see then just adding a Formula Tool with question set to Substring([Questions],1,1) will do it. There are other options if the example data is not constrained as so.

Pulsar

Here are 2 methods to do it, the 1st with a regular expression and the 2nd using findstring and replace functions

 

new column with number.png

Labels