Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached but I did not Join Multiple, I chose to Union instead as it allows further analysis on just what the trade-offs were.
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!!
suggar with two g's wow
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.
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!!