alteryx Community

# 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.

## Challenge #345: World Cup Sweepstakes (Part 2)

Moderator

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

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.

16 - Nebula
Spoiler
8 - Asteroid

Tabling tables... learnt something new today

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

Spoiler

Now to figure out table formatting options...

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
16 - Nebula

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

Spoiler
12 - Quasar
Spoiler

17 - Castor

My solution!

Spoiler

11 - Bolide
Spoiler
slight deviation in formatting and in column headers in the tables
16 - Nebula
Spoiler
Go team USA!

8 - Asteroid
Spoiler
Solution Attached