Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #63: Data Preperation Using Pivot Tools

SJKIM
8 - Asteroid

Completed - 2 Way

mshishido
8 - Asteroid

nice one

karlhansen
9 - Comet
Spoiler
solution_63.png
rebecca_petter
8 - Asteroid

Done

cmoussa
8 - Asteroid

WF.png

 

fluteman
9 - Comet

I used some macros to make the transformation cleaner.

 

I couldn;t figure out how to make a dynamic iterative macro based on column #. I started it, but sputtered.

robert-headington
8 - Asteroid

#63

martinson
11 - Bolide

Cool

Cheers,
martinson

LinkedIN

Bulien
myastarling
11 - Bolide

Here's my solution. I feel like this could be a lot more efficient than what I did here, but it got the job done.

Tofel
9 - Comet
Spoiler
Challenge 63.jpg