Challenge #38: Data Blending for Batch Output

[karlhansen]

Spoiler

[pmyers]

My solution attached.

[JHerzog5839]

Spoiler

Spoiler

[amjadmanasra]

Hello Data Hero

attached is different solution for this challenge , and it has the following modifications:

1- this implementation will always ensure to create 15 file even if the data did not contain all possible combination of (region and product)

2- it has minor data cleansing early on the stream to ensure lookups data (region and products) are clean

3- I believe using Append File to perform (Cartesian Join) between the lookups (Region and Product) and then perform one Union Join with the main data set better from performance point of view 

4- this solution using latest Alteryx designer up to 2022 

*different take on the solution for this challenge 

Enjoy :)

.

[Travis_Ratliff]

Solved

[Thomas_Wells_2dot0]

I guess I created my dynamic filename a little differently... so instead of 'Region1_Product1.csv' it's more descriptive and named like this: "AMERICAS1_Metal.csv'".

Below is the Filename formula and the preview:

Spoiler

Filename:
"'C:\USERS\DOCUMENTS\PRODUCT_OUTPUT\"+[Region] + tostring([Region Key])+"_"+[Product Group]+".csv'"

 

Here is how I would configure the output: 

Spoiler

 

[nidhirana15]

Solution

[Krzysztof_Ch]

Spoiler

[RMdL]

DONE! 

Spoiler

[palacioielle]

Nice challenge!!