Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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
Nebula
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.
Magnetar
Magnetar

My solution, same old same old. 

Spoiler
WeeklyChallenge38.JPG
Highlighted
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
Magnetar
Magnetar

Nothing new here

Highlighted
Alteryx Certified Partner

First time at using a batch output, nice functionality

 

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