In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

Deliverance
7 - Meteor

@asteryx This is what my solution was also. The business user of this report would want to see the product/region names, not "random" numbers.  I couldn't figure out why everyone was using ToString until I opened another workflow and looked at the output file name column.

asteryx
8 - Asteroid

Ah! - All is clear,

Thanks, @Deliverance .

Greg_Murray
12 - Quasar

solution attached

kaustubh
5 - Atom

Hi ,

 

Almost same the solution.

myastarling
11 - Bolide

I'm kind of scratching my head about the field that other people are creating with the formula tool because that field isn't in the sample output. here's my solution -- it matches the output, but doesn't include the additional field that other people are including.

myastarling
11 - Bolide

Ok I think I'm getting it... It's not that the output is the actual output, it's that once these are exported to a csv file, that is what you should be seeing in one file. It's just a coinky dink that that sample output also has 15 rows. Here goes attempt #2

MartinLuus
7 - Meteor
 
KaleyVolk1
7 - Meteor

I just started using this application (love it btw) and here is my solution!

DataG8
8 - Asteroid

Input/Output tools might by my kryptonite. They trip me up all the time.

Spoiler
Spoiler.PNG
AndrewRein
8 - Asteroid