Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

euanwilson
8 - Asteroid

9th challenge completed. 

 

Spoiler
So for the first join I paired the Data and Region Preference inputs and then to complete the cross join I then paired that join with the Product Group Reference. I then used a select tool to discard the duplicate columns. Then the Formula tool was used to create the Product-Region combinations files. Then the select and sort tools were used to tidy up the solution to match the output given in the question. 

Workflow.PNG
Shelbey
Alteryx
Alteryx
Spoiler

Shelbey_0-1623172826020.png

 

 

JonServiceNow
7 - Meteor

Studying for the exam. The output name is key which caused me to stumble for a bit. I did not realize you could do so many outputs like this.

LimsKragma
7 - Meteor
Spoiler
Spoiler LimsKragma_0-1623249192248.png

 

 

millerbp
8 - Asteroid

cool output!

Nethrah24
8 - Asteroid

Solution

Jonny
11 - Bolide

my solution:

 

Spoiler
Jonny_0-1624290877915.png

 

Jonny_1-1624290893869.png

 

zachcornelison
7 - Meteor

Submission attached

TKSnider
8 - Asteroid

I think the hardest part on this one was actually getting the name formatted the same way... as it isn't in a style I'd normally use personally 🙂

callie_yuan
7 - Meteor

Never Giveup