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

zackli
7 - Meteor

@romie75 Hello! There are probably many reasons why we convert region and product names to numbers. One I can think of is space efficiency in database systems such as SQL where instead of duplicating names for every record which can be very long, a number is used in place to reference that particular region or product, so instead of "americas" we would have "1". That is probably why in this challenge we are blending data with reference tables, because this is how some database systems work, with tables referencing other tables. In an SQL database we could drop the columns with the long names and keep the region/product key columns and have them be referencing their respective reference tables.

 

The "toString" function is there to convert the region/product key datatype to string so it can be written in the string "FileName" output.

 

@rijuthavposted a useful link to understanding the formula and output tools, especially for Excel, check it out here:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Output-to-separate-Excel-files/ta-p/1247

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1626090011455.png

 

aravind_sk
8 - Asteroid
Spoiler
aravind_sk_0-1626411022453.png

 

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-18 211253.pngScreenshot 2021-07-18 211321.png

  

jcasto
8 - Asteroid

Done!

Elias_Nordlinder
11 - Bolide

My solution,

 

Similar to others:

 

Spoiler
Elias_Nordlinder_0-1626785007930.png

 

NicoleDuhamel
8 - Asteroid

solution attached

Inactive User
Not applicable

Capture.JPG

Inactive User
Not applicable

Hello,

 

Attached here is my solution for Challenge 1

 

Cheers !

RashedDS
8 - Asteroid

My solution