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:\ProgramData\Alteryx\Engine\Engine_722228_02b32c29fa994ba892103f3009dd9def_\Engine_852140_b99de6e7abc54dabaad8100f2a61817e_.yxdb Single Profile C:\ProgramData\Alteryx\Engine\Engine_722228_02b32c29fa994ba892103f3009dd9def_\Engine_852140_3a78fbc091cf4f4c8ec392ea603aa1fb_.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 AMERICAS 1 EMEA 2 ASPAC 3 All 0 Region Reference C:\ProgramData\Alteryx\Engine\Engine_722228_02b32c29fa994ba892103f3009dd9def_\Engine_852140_d8051d891f974d08a51ecc3fe8c6abd4_.yxdb Spot 1 Swap 2 Option 3 Metal 4 Outrights 5 All 0 less than 20 Product Group Reference C:\ProgramData\Alteryx\Engine\Engine_722228_02b32c29fa994ba892103f3009dd9def_\Engine_852140_9dfed23ac352444ba9b8e137e29b181c_.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' Error [Product Group] = "Spot" AND [Region] = "AMERICAS" Custom = Product Group True fixed 2019-06-27 08:31:35 0 Spot 2019-06-27 08:31:35 2019-06-27 08:31:35 [Product Group] = "Spot" AND [Region] = "AMERICAS" C:\Users\kvolkmann\Downloads\Challenge38.csv CRLF , False True 28591 True Suffix Region_New Challenge38.csv Text _New Suffix ToString([Analysis Data Row])+[Product Group]+[Region] ToString([Analysis Data Row])+[Product Group]+[Region] Horizontal challenge_38_start_file