Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy method was the same after the join, but different before. I also used the formula tool, as it was only four lines of if-then. However, I've reviewed the more generaliseable solution in case I need to type too much in the formula shape.
I personally wouldn't take up a whole shape to rename two columns that are deleted in the next step though.
Think I got it 😄
Enjoyed my first ever Weekly Challenge and used the Generate Rows tool for the first time (even if i have used Alteryx for a while now