Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose Issue

Jo-B
8 - Asteroid

Dear all, 

 

I did today a lot of trail and error on the following issue.

 

I have a certain data set with many columns (Question Scores and Comments to each Questions). 

 

IDQ1Q1-CommentsQ2Q2 CommentsQ3...
110def9abc2 
29xyz10abc6 

 

I am looking for the following layout to filter on on the different questions and comments.

 

IDQuestionScoreComments
1110def

1

29abc
13.....

 

I know to transpose the column related to the scores of the questions, however how I can assign the right comment to the correct row?

 

I appreciate your help!

 

Cheers, 

Johanna

 

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

You need to do a little post processing after the transpose something like:

2017-11-07_20-29-50.jpg

 

This uses Regex to get the question number then a crosstab to put back together

 

Sample attached.

mrichards
6 - Meteoroid

You could also try it with a multi-row formula followed by a filter (workflow attached).ScreenHunter_244 Nov. 07 16.12.jpg

Jo-B
8 - Asteroid

Dear  Both,

 

I could work with solution 2, although #1 is also quite Logical, however with my data i was a bit confused....

 

Thanks to you both!!

 

 

Best Regards,

Johanna

Labels