Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA#291
The solution has several columns with identical names. Try as I might, I was unable to get Alteryx to do this. I'm on 2021.4 though so I've told myself it's because of that.
Column name frustrations:
The embedded select says Input_#2 has sugarless candy as a field but Input 2 doesn't have that field!:
Attempting to force a change in column names with a Select tool:
Anyway, here's my solution:
Wish I'd thought of join multiple. Lesson learnt!