Challenge #273: Filling In The Blanks

[Emil_Kos]

Hi,

That was fun

[johnzrgu75]

Spoiler

[nlensing001]

My solution

Spoiler

[amir_alteryx_2021]

Spoiler

[RichoBsJ]

Hi! Here my solution 🙂

[Maskell_Rascal]

I loved seeing everyone's approach to solving this problem, and also kick myself for not thinking of using the generate rows tool! Even when submitting the challenge, I learn something new. 🤓

The solution provided was one of two different ways we had originally come up with building the workflow. Below is the second approach which utilizes an Advanced Join macro that is available on the gallery. 

Spoiler

Cheers!

Phil

[AngelosPachis]

My solution to challenge 273 

Spoiler

[KaneG]

I love the chance to use a join as a filter...

Spoiler

Redundant Select tools, but I like having them separate to the Join

[YoshiroFujimori]

I like Cross Tab and Transpose.

Spoiler

[jpowellsd]

Good practice with generate rows

Spoiler