Challenge #38: Data Blending for Batch Output

[AbbieRoss-Carter]

Spoiler

[JennyMartin]

Spoiler

Awesome feature of Alteryx.

[SueDonim]

Spoiler

Came close to the common answer, but was having trouble with the Formula tool (probably because my syntax was wrong)

- Find/Replace to lookup Region Code

- Find/Replace to lookup Product Code

- Select Tool to change Region and Product Codes to string

- Multi-Field Formula to add field with desired file name

- Select Tool to change desired file name field to "Filename" (really not needed ultimately)

- Output tool separating files by field "Filename"

Lessons learned:

- Outputting to multiple files based on field

- Using tool for lookup

Very handy exercise

[kmcdaniel]

Spoiler

Joins to add in Regions and Product keys.

Filters to get specific Region Key subsets.

Output data tools to create .csv files and append Product key values in the filenames.

[jusdespommes]

Super functionality, as ever 🙂

Spoiler

[BSilverblatt]

Thanks for the challenge! This is my solution.

[RRS]

My Solution

[Billigans]

Spoiler