Free Trial

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

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1613154271564.png

 

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1613338884036.png

 

TheOC
15 - Aurora
15 - Aurora

a bit of an awkward one, although surprisingly appears in real-world application 

 

Spoiler
TheOC_0-1613476474135.png

Took me a little bit of time to work out the best way of splitting the two, recordID and filter tools are a dynamic duo!

 


Bulien
thaodinh95
8 - Asteroid

Here is my solution to this challenge! I used crosstab method instead of transpose.

p_padham
8 - Asteroid

Hi everyone!

 

Here is my solution:

 

Spoiler
challenge49_completed.png
Miguel-GS
5 - Atom

Took a while with this one - first time using the join tool, and processing at the end of the day meant I slept on it before checking and being happy enough to post here.

MohithRai
8 - Asteroid

Done!!!🚀

Spoiler
MohithRai_0-1613728717945.png

 

 

Hub119
11 - Bolide
11 - Bolide

Solution attached.

garrettlem1017
8 - Asteroid

Solution has been attached.

annaprosvetova
7 - Meteor

Here is my solution for this challenge

 

Spoiler
annaprosvetova_0-1614164451373.png