Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #49: Reformatting Transactional Data

ainderike
8 - Asteroid

I got there, but I feel like my solution is too complex. Curious to see other options.

Spoiler
ainderike_0-1642179841099.png

 

dipan_mitra
7 - Meteor

Dipan Mitra => Challenge #49: Reformatting Transactional Data

scoles0617
8 - Asteroid

My solution

Qusaiamer
7 - Meteor

#49

sgao
7 - Meteor

My solution uses append tool instead.

Bart777
6 - Meteoroid

Bart777_0-1642958031520.png

 

swlsherry
7 - Meteor

My solution!

markjperkins
7 - Meteor

Two options:

 

1. hard coded lookup (switch statement) based on F value to Market, Product and Type.

2. Generate a lookup from F value to Market, Product and Type from the Header rows (better).

SylwiaDragon
8 - Asteroid

Attached my super long solution.

AngelaFan
7 - Meteor

1