community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #38: Data Blending for Batch Output

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!

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
Alteryx Partner

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

 

My Solution:

 

Spoiler
Solution
Nebula
Nebula

Same solution as others (attached)

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
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

 

 

 

Pulsar
Pulsar

Nothing new here

Alteryx Certified Partner

First time at using a batch output, nice functionality

 

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