Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

danbostrom
8 - Asteroid

 

 

YadTheTabLad
8 - Asteroid

image.png

beatriz_alteryx06
8 - Asteroid

Weekly Challenge solved.

Dibas98
8 - Asteroid

Solution

ABhattacharya
7 - Meteor

Sharing my solution for Weekly Challenge #49.

Felipe_Ribeir0
16 - Nebula

Here is my solution.

Felipe_Ribeir0
16 - Nebula

Here is my solution (but like some previous folks, i also think that this survey data having two difference responses concatenated on the same column is a little strange)

 

F38
Age
8-Prefer not to answer
5-45-54
Bobbyt23
8 - Asteroid
Spoiler
Transpose Crosstab, crosstab transpose 😁 I also enjoy being able to do multiple things within the join tool, really powerful.
Rhys_Cooper
8 - Asteroid

Quite a tricky challenge - good example of how the column names can be used within the join condition after the transformations.

 

Spoiler
Capture.PNG

 

OlonJohnson
5 - Atom

Similar to other solutions. Concat + Text To Columns is a great tool combination for this issue