Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #38: Data Blending for Batch Output

Highlighted
Alteryx Alumni (Retired)

The link to the solution for last challenge #37 is HERE.

 

One of the powers of Alteryx is to be able to batch processes without the need to write scripts of use complicated code.   A single output tool can be configured to generate many output files.

 

Use Case:  A company needs to blend data from three sources and generate an output file for each product - region combination, a total of 15 output files.

 

Objective:  Create a cross join between the Product Group, Region Reference and Data tables to produce 15 unique CSV Data files.  Please note that only 1 output tool should be leveraged in your solution.

 

Thanks to all that are playing along!

Highlighted
Creative Director
Creative Director

A solution has been posted

Spoiler
2016-08-29 09_17_02-Alteryx Designer x64 BETA - Data_Blending_for_Batch_Output_Beginner_solution.yxm.png
Tara McCoy
Highlighted
Alteryx Partner

Think im getting to "involved" with these challenges - too much fun to give up.

 

My Solution:

 

Spoiler
Solution
Highlighted
16 - Nebula
16 - Nebula

Same solution as others (attached)

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Thanks,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
14 - Magnetar
14 - Magnetar

My solution, same old same old. 

Spoiler
WeeklyChallenge38.JPG
Highlighted
6 - Meteoroid

My solution. 

 

 

For Beginners , this helped me out. - https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Output-to-separate-Excel-files/ta-p/1247

 

 

 

Highlighted
14 - Magnetar
14 - Magnetar

Nothing new here

Alteryx Certified Partner

First time at using a batch output, nice functionality

 

Spoiler
Weekly Challenge 38 - files.pngWeekly Challenge 38.png
Highlighted
8 - Asteroid