ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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 #38: Data Blending for Batch Output

Kavy
Meteoroid

Batch Output Problem Solution, A separate column is created with the combination of Region(3) and Product key(5), creating a total of 15 different files

sahil_bhure
Meteor

My solution to the weekly challenge #38.

Megha1905
Meteor

sol

jamaldub1
Asteroid

Nice!

ebostwick
Asteroid

Good refresher on splitting file output.

 

Spoiler
challenge_38_SolutionSpoiler_EDB.png

chadev_ccorp
Asteroid
Spoiler
38a.JPG

 

38b.JPG

 

38c.JPG

 

Desafios Foundation: 11/11‌‌‌‌
Desafios Core: 34/40
Desafios Intermediário: 1
Prep Guid Micro-Credential: 2/18

🤓📊

GuiCasLor
Meteor

Answer

NanaAma
Meteor

All done

KLTerrell
Asteroid

I'm not sure if I'm missing something major here, but I don't see the need to join the tables, the original Data table contains Product and Region references, so I built a formula from just that table then sent the data to the 15 separate CSVs referencing the new region_product field. 

 

Spoiler
Alteryx Challenge 38.png

Challenge #38 Solution