Input
Output (1 of 15 separate files)
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #38
Data Blending for Batch Output:
Use Case: A company need to blend data from three sources and generate an output file for each product - region combination, a total of 15 output files.
Objective: Create a cross join between the Product Group, Region Reference and Data tables to produce 15 unique CSV Data files.
Please note that only 1 output tool should be leveraged in the solution.
C:\Users\ADMINI~1\AppData\Local\Temp\Engine_3864_494aa80ca9c840f0aa4bc754f7d10aa6_\Engine_5288_6a88ee27f5444115b38a490b9f3e973c_.yxdb
C:\Users\ADMINI~1\AppData\Local\Temp\Engine_3864_494aa80ca9c840f0aa4bc754f7d10aa6_\Engine_5288_459d47174e2a4718a72db72566b870ea_.yxdb
1
1
Spot
OTHER
Bank
AMERICAS
98063673.2963549
1
2
68
Swap
LATAM
Bank
AMERICAS
92095496.6251977
1
3
111
Option
LATAM
Bank
AMERICAS
74601207.2795048
1
4
199
Metal
OTHER
Hedge Fund
AMERICAS
32732092.0634624
1
5
294
Outrights
G10
Real Money
EMEA
47219462.415872
1
6
315
Spot
LATAM
Bank
AMERICAS
70777456.6912632
1
7
323
Spot
LATAM
Hedge Fund
AMERICAS
88022499.9776014
1
8
403
Swap
OTHER
Real Money
AMERICAS
44565062.8202637
1
9
438
Metal
G10
Bank
EMEA
25134049.7363391
1
10
453
Spot
OTHER
Hedge Fund
EMEA
63451519.6201598
1
11
552
Spot
OTHER
Real Money
ASPAC
88573573.6270243
1
12
598
Outrights
G10
Bank
AMERICAS
57443741.2002105
1
13
668
Swap
G10
Bank
AMERICAS
77661745.9659599
1
14
719
Outrights
G10
Bank
EMEA
78962582.5947768
-1
15
736
Swap
G10
Hedge Fund
EMEA
61637944.7432494
-1
16
772
Option
LATAM
Real Money
ASPAC
61073920.6060166
-1
17
796
Swap
LATAM
Bank
AMERICAS
63712711.3384272
-1
18
889
Option
OTHER
Hedge Fund
AMERICAS
72462523.4096128
-1
19
962
Option
G10
Real Money
EMEA
5592521.98927644
-1
20
997
Metal
OTHER
Bank
EMEA
7540158.25773429
-1
21
1003
Spot
G10
Hedge Fund
ASPAC
47219462.415872
-1
22
1049
Spot
G10
Real Money
EMEA
70777456.6912632
1
23
1073
Outrights
G10
Bank
EMEA
88022499.9776014
1
24
1
Spot
G10
Hedge Fund
AMERICAS
44565062.8202637
1
25
68
Swap
G10
Real Money
AMERICAS
92095496.6251977
1
26
111
Option
G10
Bank
AMERICAS
74601207.2795048
1
27
719
Metal
LATAM
Hedge Fund
AMERICAS
32732092.0634624
1
28
736
Outrights
LATAM
Real Money
EMEA
47219462.415872
1
29
772
Spot
OTHER
Bank
AMERICAS
70777456.6912632
1
30
796
Spot
G10
Hedge Fund
AMERICAS
88022499.9776014
1
31
889
Swap
OTHER
Real Money
AMERICAS
44565062.8202637
1
32
962
Spot
G10
Bank
AMERICAS
25134049.7363391
1
33
997
Swap
G10
Hedge Fund
EMEA
63451519.6201598
1
34
1003
Metal
G10
Real Money
AMERICAS
88573573.6270243
1
35
598
Spot
OTHER
Bank
AMERICAS
57443741.2002105
1
36
668
Spot
LATAM
Real Money
AMERICAS
72462523.4096128
-1
37
719
Outrights
LATAM
Bank
EMEA
5592521.98927644
-1
38
736
Swap
G10
Hedge Fund
AMERICAS
7540158.25773429
1
39
199
Outrights
LATAM
Real Money
AMERICAS
47219462.415872
1
40
294
Option
LATAM
Bank
EMEA
70777456.6912632
1
41
315
Metal
OTHER
Hedge Fund
EMEA
88022499.9776014
1
42
323
Option
G10
Real Money
ASPAC
44565062.8202637
1
43
403
Metal
OTHER
Bank
EMEA
92095496.6251977
1
44
438
Outrights
G10
Hedge Fund
EMEA
74601207.2795048
1
45
453
Spot
G10
Bank
AMERICAS
32732092.0634624
1
46
1073
Swap
G10
Hedge Fund
EMEA
47219462.415872
1
47
323
Spot
G10
Real Money
EMEA
96597040.8492812
1
48
199
Swap
G10
Bank
EMEA
80755383.136124
1
49
294
Metal
G10
Real Money
ASPAC
84504181.1718547
1
50
315
Spot
G10
Bank
AMERICAS
88252979.2075853
1
51
323
Metal
LATAM
Hedge Fund
AMERICAS
92001777.243316
1
52
403
Spot
LATAM
Real Money
EMEA
95750575.2790467
1
53
438
Spot
OTHER
Bank
EMEA
99499373.3147774
1
54
453
Outrights
G10
Bank
ASPAC
103248171.350508
1
55
552
Swap
OTHER
Hedge Fund
AMERICAS
106996969.386239
1
56
598
Outrights
G10
Real Money
AMERICAS
110745767.421969
-1
57
668
Swap
G10
Bank
EMEA
114494565.4577
-1
58
719
Swap
G10
Hedge Fund
EMEA
118243363.493431
-1
59
736
Metal
G10
Real Money
ASPAC
121992161.529161
-1
60
719
Spot
G10
Bank
AMERICAS
125740959.564892
-1
61
736
Spot
LATAM
Hedge Fund
AMERICAS
129489757.600623
-1
62
772
Metal
LATAM
Real Money
EMEA
133238555.636354
-1
63
796
Outrights
OTHER
Bank
EMEA
136987353.672084
-1
64
889
Spot
G10
Hedge Fund
ASPAC
140736151.707815
1
65
962
Spot
OTHER
Bank
AMERICAS
144484949.743545
1
66
997
Swap
G10
Hedge Fund
AMERICAS
148233747.779276
1
67
962
Metal
G10
Real Money
EMEA
151982545.815007
1
68
997
Spot
G10
Bank
AMERICAS
155731343.850737
1
69
1003
Spot
G10
Real Money
EMEA
159480141.886468
1
70
1049
Outrights
LATAM
Bank
AMERICAS
163228939.922199
1
71
1073
Swap
LATAM
Hedge Fund
AMERICAS
166977737.957929
1
72
1
Swap
OTHER
Real Money
AMERICAS
170726535.99366
1
73
403
Metal
G10
Bank
EMEA
174475334.029391
1
74
438
Spot
OTHER
Bank
EMEA
178224132.065121
1
75
453
Spot
G10
Hedge Fund
EMEA
181972930.100852
1
76
1073
Outrights
G10
Real Money
ASPAC
185721728.136583
1
77
323
Swap
G10
Bank
AMERICAS
74601207.2795048
1
78
199
Swap
OTHER
Hedge Fund
AMERICAS
32732092.0634624
1
79
294
Option
LATAM
Hedge Fund
EMEA
47219462.415872
1
80
315
Metal
OTHER
Real Money
EMEA
70777456.6912632
1
81
719
Outrights
G10
Bank
ASPAC
47219462.415872
1
82
736
Spot
OTHER
Real Money
EMEA
70777456.6912632
1
83
772
Spot
G10
Bank
EMEA
88022499.9776014
-1
84
796
Swap
G10
Hedge Fund
ASPAC
44565062.8202637
1
85
889
Metal
G11
Hedge Fund
EMEA
445445062.820263
Data
Data
AMERICAS
1
EMEA
2
ASPAC
3
All
0
Region Reference
Region Reference
C:\Users\ADMINI~1\AppData\Local\Temp\Engine_3864_494aa80ca9c840f0aa4bc754f7d10aa6_\Engine_5288_83e360396e914af4b75ad5a1a32b4eea_.yxdb
Spot
1
Swap
2
Option
3
Metal
4
Outrights
5
All
0
less than 20
Product Group Reference
Product Group Reference
C:\Users\ADMINI~1\AppData\Local\Temp\Engine_3864_494aa80ca9c840f0aa4bc754f7d10aa6_\Engine_5288_ce343e2f80b243749e32487d9276bd36_.yxdb
1
1
Spot
OTHER
Bank
AMERICAS
98063673.2963549
1
1
1
6
315
Spot
LATAM
Bank
AMERICAS
70777456.6912632
1
1
1
7
323
Spot
LATAM
Hedge Fund
AMERICAS
88022499.9776014
1
1
1
24
1
Spot
G10
Hedge Fund
AMERICAS
44565062.8202637
1
1
1
29
772
Spot
OTHER
Bank
AMERICAS
70777456.6912632
1
1
1
30
796
Spot
G10
Hedge Fund
AMERICAS
88022499.9776014
1
1
1
32
962
Spot
G10
Bank
AMERICAS
25134049.7363391
1
1
1
35
598
Spot
OTHER
Bank
AMERICAS
57443741.2002105
1
1
1
36
668
Spot
LATAM
Real Money
AMERICAS
72462523.4096128
-1
1
1
45
453
Spot
G10
Bank
AMERICAS
32732092.0634624
1
1
1
50
315
Spot
G10
Bank
AMERICAS
88252979.2075853
1
1
1
60
719
Spot
G10
Bank
AMERICAS
125740959.564892
-1
1
1
61
736
Spot
LATAM
Hedge Fund
AMERICAS
129489757.600623
-1
1
1
65
962
Spot
OTHER
Bank
AMERICAS
144484949.743545
1
1
1
68
997
Spot
G10
Bank
AMERICAS
155731343.850737
1
1
1
Example output file name: 'Region1_Product1.csv'
Example output file name: 'Region1_Product1.csv'
Join the Region Key to the Data
Join the Region Key to the Data
Join the Product Key to the data
Join the Product Key to the data
Create and output name for the files
Output_Name = "Region"+tostring([Region Key])+"_"+"Product"+tostring([Product Ke...
.\output.csv
CRLF
,
False
True
28591
True
FileName
Output_Name
output.csv
Horizontal
challenge_38_solution