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

New to Alteryx Designer

Inactive User
Not applicable

Alteryx Community,

 

I am brand new to Alteryx and this is my first question to the community. 

 

I have an input of a single column of data containing 20 names, one per row (most first and last, but some have a middle).

 

I have a second input of 10 characteristics (friendly, punctual, etc.) along with a rating for each person above in a single row. 

For example: Friendly 3.8 3.5 4.0 3.9 2.4 3.8 3.4 3.6 .......... etc

 

I would like to get an Output via Browse that pulls from the two inputs and lists all of the 10 characteristics in the first column, followed by the corresponding rating for each person in columns to follow. 

For example: 

CharacteristicJon DoeJane DoeFrank Darren SmithT. Barber
Friendly3.83.54.03.9
Punctual3.02.93.8

3.9

 

Can anyone point me in the right direction to get me started? What tools do you feel are required to get from the starting point to the ending point?

 

11 REPLIES 11
IraWatt
17 - Castor
17 - Castor

Yeah very much agreed @Inactive User , it is a little awkward the alphabetizing in this case. I've added an idea to the community about it: Option to not Alphabetize Cross Tab Headers - Alteryx Community

Thank you so much! Two follow-up questions, if you don't mind -- (1) my numbers are decimals; how would I alter the RegEx expression to account for a decimal numbers like 2.1 ?  (2) what purpose does the Formula early on in the workflow with Empty = Null () serve? Thanks again! 

Labels
Top Solution Authors