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

mulvihi11
8 - Asteroid

Anyone else use 18 filter tools? Nope? Just me? OK, cool. Got it.

 

jguerrero
Alteryx
Alteryx

My solution

jyojyoti
6 - Meteoroid

Hi, 

here you go

deviseetharaman
11 - Bolide
Spoiler
 
izamryan
8 - Asteroid

Joins R Us!

 

Spoiler
izamryan_0-1590147959377.png


I used two Joins and then a Select. I used the Select to simplify the Formula which I don't need to change data types now:

"Region " + [Region Key] + " - " + "Product " + [Product Key]

 

 

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590151821801.png

 

cc000072
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_38.JPG
JohanRanschaert
8 - Asteroid
Spoiler
JohanRanschaert_0-1590494698158.png
Spoiler
JohanRanschaert_0-1590494836397.png

 

In attach my solution

allan_ap52
5 - Atom

My solution for this, using a JOIN with FORMULA based in some conditions to create a new column. After this new column I divide in 15 files.

nravik
11 - Bolide

Solution attached. 

 

Spoiler
38.PNG

Thanks!! #7