Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #345: World Cup Sweepstakes (Part 2)

LukeM
Moderator
Moderator

A solution to last week’s challenge can be found here.image_345.png

 

Last week you were able to hold the sweepstakes draw by randomly matching teams with your participants (rather than them pulling team names from a hat). This week we will be creating a report for each participant so they can see their teams and when they are playing.

 

Build a workflow to format the fixtures (match, date, teams) and then create a record for each team and their opposition in the group stages. Each team has three matches, with a match number and a date for each match.

 

Then take the participants from last week's challenge and join them with their teams in order to create a PDF report for each person. The report should include a section for each participant and should feature details on each team they have drawn including their rank, group, and a table of their World Cup fixtures.

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
R345.jpgW345.jpg
DanFlint
8 - Asteroid

Tabling tables... learnt something new today

Table formatting isn't as pretty as the given output, but the data matches

Spoiler
DanFlint_0-1668435246435.pngDanFlint_1-1668435260171.png

 

 

Now to figure out table formatting options...

DataNath
17 - Castor

My solution to #345. Spent ages trying to figure out how on earth my joins didn't line up to then just realise that the provided output is just an example and the pairings in the input aren't the same.

 

Spoiler
DataNath_0-1668435845376.png
alexnajm
16 - Nebula
16 - Nebula

Can't wait to be at the World Cup shortly!

Spoiler
Challenge 345.PNG
MilindG
12 - Quasar
Spoiler
MilindG_0-1668439033429.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
AkimasaKajitani_0-1668439113299.png
AkimasaKajitani_0-1668439221576.png
 

 

 

RWvanLeeuwen
11 - Bolide
Spoiler
slight deviation in formatting and in column headers in the tablesslight deviation in formatting and in column headers in the tables
Kenda
16 - Nebula
16 - Nebula
Spoiler
Go team USA!
Kenda_0-1668439587661.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1668443371339.png