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 #274: Concattributes

Jonny
11 - Bolide

my solution:

Spoiler
Jonny_0-1625488235379.png

 

mbogusz
9 - Comet
Spoiler
Challenge #274 in the canChallenge #274 in the can
ArtApa
Alteryx
Alteryx

Here is my solution:

 

Spoiler
ArtApa_0-1625604266862.png

 

KieranAdair
7 - Meteor

All solved 🙂 Really interesting challenge

cwkoops
8 - Asteroid

1st time concatenating with the Summarize tool 

OllieClarke
15 - Aurora
15 - Aurora

Disagreed with the output a bit

Spoiler

Went with powers = T/F and measurements being everything else

OllieClarke_0-1625653944144.png

 

AndrewS
11 - Bolide

#274

Spoiler
274.PNG
Laurap1228
11 - Bolide

Here is my solution:

Spoiler
Laurap1228_0-1625775607467.png

 

vaprevil
7 - Meteor

Here is my solution

dhavaldoshi
8 - Asteroid

How to do it as a beginner?

  • Transpose - You'll always have data coming from different streams, multiple joins - However when working with reports/tableau you'll need them as dimensions and measures
  • Concatenation - It is key to reduce extra rows incase the output is important
Spoiler
Solution_274.png