Challenge #291: A Winning Halloween Candy Basket

[KaneG]

Solution attached but I did not Join Multiple, I chose to Union instead as it allows further analysis on just what the trade-offs were.

Spoiler

[Wojtek_Dz]

Spoiler

[NicoleJohnson]

My (tasty!) solution!

Spoiler

Cheers!

NJ

[TapasTR]

Spoiler

 

Here's my solution.

I wanted to understand how are the names of the column "peanutyalmondy" remaining same when one uses a select tool? I believe how alteryx runs is that no 2 columns can have same headers!!

[mbogusz]

suggar with two g's wow

Spoiler

#291 in the can

[Harrylosborne]

Spoiler

[tammybrown_tds]

@TapasTR,

I added spaces to the second and third occurrences of the peanutyalmondy column.

So I have three columns (where "_" represents a space):

peanutyalmondy

peanutyalmondy_

peanutyalmondy_ _

Not sure if there is any other way to do it, but that's how I did it.

[Michael_McKee]

Spoiler

 

[skhani]

Hello everyone,

Just started learning Alteryx a couple of weeks ago! Super grateful for the community and these challenges for making learning fun & interesting. 

May have went a little overboard with extra details but figured I'd use all these tools for the sake of solidifying my understanding of them.

That said, I do have a question for anyone who may have an answer! Is there a better way to rank multiple columns more dynamically rather than one by one as almost all of us have done? I assume the multi-row formula is useful in this case; however, my understanding of it isn't too advanced yet.

Any insight is much appreciated, thank you!!

[jagdeep_singh85]

Hi

PFA my solution.

Thanks

Jagdeep Singh