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:
Characteristic | Jon Doe | Jane Doe | Frank Darren Smith | T. Barber |
Friendly | 3.8 | 3.5 | 4.0 | 3.9 |
Punctual | 3.0 | 2.9 | 3.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?
Solved! Go to Solution.
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!