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==
Défi hebdomadaire #4
Manipuler des données - Reformater des données
Un client possède des données fournies avec des informations clés sur les produits en haut du fichier. Chaque colonne de données contient trois lignes d'informations en en-tête par produit :
• Product (Produit)
• Market (Marché)
• Type (Catégorie)
Le client souhaite que ces informations soient affichées en lignes pour chaque produit.
PRODUCT
Product A
Product B
Product C
Product D
MARKET
Market A
Market B
Market C
Market D
TYPE
Type A
Type B
Type C
2005-01-01
933
389.10500000000002
393.46100000000001
1020
2005-02-01
770
412.49299999999999
416.49299999999999
970
2005-03-01
770
472.351
477.76799999999997
970
2005-04-01
715
466.91699999999997
471.762
930
2005-05-01
613
414.13799999999998
418.76299999999998
880
2005-06-01
530
433.67
437.67
840
2005-07-01
576
464.363
468.363
840
2005-08-01
680
523.77300000000002
527.77300000000002
920
2005-09-01
895
566.55999999999995
570.55999999999995
1020
2005-10-01
1063
542.26199999999994
546.26199999999994
1200
2005-11-01
820
476.58800000000002
480.58800000000002
1160
2005-12-01
770
494.113
498.113
1030
2006-01-01
822
557.46299999999997
561.46299999999997
1030
2006-02-01
1010
520.64499999999998
524.63800000000003
1090
2006-03-01
965
523.81500000000005
527.81500000000005
1110
2006-04-01
910
587.23599999999999
591.23599999999999
1130
2006-05-01
943
596.59500000000003
600.63099999999997
1180
2006-06-01
921
611
615
1200
2006-07-01
948
639.197
643.197
1200
2006-08-01
1056
616.43200000000002
620.43200000000002
1225
2006-09-01
1100
520.5
521.9
1275
2006-10-01
1109
504
507.98899999999998
1255
2006-11-01
1041
511.16300000000001
515.16300000000001
1200
2006-12-01
970
541.77599999999995
545.77599999999995
1150
2007-01-01
957
505.65499999999997
509.65499999999997
1170
2007-02-01
983
547.57899999999995
552.10500000000002
1190
2007-03-01
921
600.30700000000002
604.30700000000002
1205
2007-04-01
940
653.16399999999999
657.18399999999997
1230
2007-05-01
941
682.34500000000003
686.34500000000003
1250
2007-06-01
911
663.82100000000003
667.66700000000003
1270
2007-07-01
933
680.63099999999997
684.26199999999994
1295
2007-08-01
965
641.86400000000003
645.61400000000003
1310
2007-09-01
980
692.64499999999998
697.15800000000002
1320
2007-10-01
1006
749.22799999999995
745.65200000000004
1320
2007-11-01
949
821.11900000000003
825.11900000000003
1300
2007-12-01
967
840.23500000000001
837.529
1300
2008-01-01
969
824.78599999999994
828.78599999999994
1350
2008-02-01
976
828.96299999999997
832.21299999999997
1350
2008-03-01
1005
860.95799999999997
864.95799999999997
1340
2008-04-01
1025
903.28399999999999
905.01099999999997
1320
2008-05-01
1027.5
982.96299999999997
986.96299999999997
1300
2008-06-01
1126
1087.857
1091.857
1330
2008-07-01
1204
1074.2159999999999
1078.2159999999999
1495
2008-08-01
1180
951.41300000000001
955.41300000000001
1525
2008-09-01
1022
839.06
843.06
1485
2008-10-01
801
524.75
528.75
1235
2008-11-01
688
301.66699999999997
305.66699999999997
950
2008-12-01
530
254.167
258.16699999999997
800
2009-01-01
525
348.36900000000003
352.13099999999997
780
2009-02-01
606
393.738
397.738
820
2009-03-01
630
394.36399999999998
398.18200000000002
880
2009-04-01
566
421.55
425.55
880
2009-05-01
570
473.22399999999999
477.22399999999999
870
2009-06-01
615
564.66999999999996
568.69299999999998
890
2009-07-01
688
552.28300000000002
556.28300000000002
990
2009-08-01
798.75
637.68799999999999
641.98099999999999
1020
2009-09-01
810
592.375
596.375
1110
2009-10-01
740.625
624.976
628.976
1070
2009-11-01
730
670.25
674.25
1020
2009-12-01
746
678.78099999999995
684.125
1020
2010-01-01
836.25
711.06600000000003
715.06600000000003
1080
2010-02-01
841.25
676.03899999999999
680.82899999999995
1160
2010-03-01
819
727.41300000000001
731.41300000000001
1160
2010-04-01
812.5
732.82500000000005
736.82500000000005
1180
2010-05-01
887.5
677.23699999999997
681.23699999999997
1190
2010-06-01
940
655.26099999999997
659.26099999999997
1190
2010-07-01
915
625.01199999999994
629.01199999999994
1175
2010-08-01
948.75
659.57100000000003
662.51199999999994
1150
2010-09-01
927
676.351
682.774
1140
2010-10-01
915
751.202
755.20299999999997
1130
2010-11-01
938.75
776.32500000000005
780.32500000000005
1150
2010-12-01
994
837.3
841.3
1190
2011-01-01
1090
850.32899999999995
854.32899999999995
1310
2011-02-01
1113.125
877.63800000000003
881.63800000000003
1360
2011-03-01
1155
977.44600000000003
981.44600000000003
1440
2011-04-01
1195
1048.681
1052.681
1460
2011-05-01
1205.625
982.41300000000001
986.41300000000001
1475
2011-06-01
980
929.31799999999998
933.31799999999998
1420
2011-07-01
886.25
975.798
979.798
1320
2011-08-01
989
936.125
940.125
1325
2011-09-01
992.5
936.04499999999996
940.04499999999996
1320
2011-10-01
951.25
878.34500000000003
882.34500000000003
1320
2011-11-01
908
860.61400000000003
864.61400000000003
1280
2011-12-01
881.25
872.68799999999999
876.68799999999999
1260
2012-01-01
1036.25
946.60699999999997
950.60699999999997
1315
2012-02-01
1200
1022.881
1026.8810000000001
1440
2012-03-01
1303.75
1064.8409999999999
1068.8409999999999
1550
2012-04-01
1243.75
1025.5129999999999
1029.5129999999999
1585
2012-05-01
1035
873.11400000000003
877.11400000000003
1530
2012-06-01
856.25
725.48699999999997
729.48699999999997
1360
2012-07-01
935
821.39800000000002
825.39800000000002
1240
2012-08-01
1110
931.18200000000002
935.18200000000002
1400
2012-09-01
1222.5
962.06299999999999
966.06299999999999
1560
2012-10-01
1197
950.58699999999999
954.58699999999999
1520
2012-11-01
1150
926.98900000000003
930.98900000000003
1480
2012-12-01
1065
934.47400000000005
938.47400000000005
1480
2013-01-01
1154
150
932.95500000000004
1510
2013-02-01
1182.5
942
991.86300000000006
1510
2013-03-01
1116.25
286
910.28800000000001
1525
2013-04-01
1037.5
642
815.702
1460
2013-05-01
932.5
677
833.202
1370
2013-06-01
975
143
843.6
1390
2013-07-01
1031
588
876.79
1390
2013-08-01
1097.5
321
913.88
1430
2013-09-01
1107.5
261
929.81
1480
2013-10-01
1030
707
901.87
1430
2013-11-01
980
380
929.33
1395
2013-12-01
971
923
956.78
1420
2014-01-01
998
518
918.58
1440
2014-02-01
940
495
913.65
1400
2014-03-01
902.5
516
911.4
1380
2014-04-01
872.5
93
925.61
1370
2014-05-01
891.875
566
937.84
1370
2014-06-01
992.5
454
952.45
1380
2014-07-01
1033
627
935.51
1420
2014-08-01
1003.75
998
865.81
1400
2014-09-01
923.75
813
842.82
1345
2014-10-01
993
872
711.52
1345
2014-11-01
997.5
223
628.94000000000005
1280
2014-12-01
869
511
491.98
1245
2015-01-01
710.63
391.34
396.9
1125
2015-02-01
753.13
496.5
502.13
1070
2015-03-01
118
819
504.86
1200
2015-04-01
292
485
666
684
2015-05-01
570
339
160
704
2015-06-01
483
353
786
349
2015-07-01
630
41
682
79
2015-08-01
7
859
101
676
2015-09-01
610
927
717
944
2015-10-01
498
963
689
1
2015-11-01
442
763
0
661
2015-12-01
936
598
829
490
2016-01-01
436
131
925
737
2016-02-01
67
578
522
271
2016-03-01
704
8
369
565
2016-04-01
207
688
476
3
2016-05-01
825
904
620
401
2016-06-01
428
149
794
637
2016-07-01
496
120
93
902
2016-08-01
285
668
822
337
2016-09-01
26
315
144
542
2016-10-01
199
144
399
613
2016-11-01
969
186
778
864
2016-12-01
28
444
21
300
2017-01-01
101
486
521
332
2017-02-01
905
969
826
700
2017-03-01
923
331
99
487
2017-04-01
544
823
142
438
2017-05-01
505
520
519
872
2017-06-01
271
581
789
285
2017-07-01
668
437
865
266
2017-08-01
508
786
831
826
2017-09-01
950
995
43
759
2017-10-01
511
291
574
607
2017-11-01
548
77
559
47
2017-12-01
728
301
662
842
2018-01-01
612
219
670
76
2018-02-01
525
634
490
390
2018-03-01
533
236
481
204
2018-04-01
218
206
251
845
2018-05-01
778
210
158
306
2018-06-01
880
136
641
794
2018-07-01
458
506
446
731
2018-08-01
759
652
326
21
2018-09-01
839
905
641
306
2018-10-01
511
962
317
848
2018-11-01
201
738
759
575
2018-12-01
682
161
964
173
2019-01-01
130
863
392
122
2019-02-01
267
666
914
372
2019-03-01
235
341
956
658
2019-04-01
220
476
605
489
2019-05-01
299
922
859
548
2019-06-01
620
93
958
406
2019-07-01
379
866
298
463
2019-08-01
181
873
435
227
2019-09-01
568
561
718
41
2019-10-01
387
763
139
837
2019-11-01
360
677
333
997
2019-12-01
88
235
432
739
2020-01-01
816
197
122
336
2020-02-01
457
302
124
93
2020-03-01
624
669
74
146
2020-04-01
659
975
903
530
2020-05-01
56
950
548
268
2020-06-01
139
997
126
536
2020-07-01
718
41
348
590
2020-08-01
184
143
830
852
2020-09-01
968
623
697
543
2020-10-01
846
264
715
150
2020-11-01
258
327
993
903
2020-12-01
820
725
914
993
2021-01-01
681
144
839
773
2021-02-01
367
269
414
178
2021-03-01
828
225
954
885
2021-04-01
15
433
673
531
2021-05-01
72
633
117
224
2021-06-01
706
483
705
797
2021-07-01
326
144
873
464
2021-08-01
420
628
889
25
2021-09-01
810
93
191
83
2021-10-01
483
817
531
329
2021-11-01
904
905
770
84
2021-12-01
342
323
68
748
2022-01-01
138
912
113
702
2022-02-01
632
689
269
669
2022-03-01
385
924
160
459
2022-04-01
103
666
511
869
2022-05-01
14
516
659
261
2022-06-01
145
203
179
308
2022-07-01
348
813
319
440
2022-08-01
722
78
261
333
2022-09-01
281
401
579
287
2022-10-01
809
158
884
298
2022-11-01
421
487
24
225
2022-12-01
957
583
180
989
2023-01-01
368
712
823
451
2023-02-01
194
666
878
740
2023-03-01
633
640
839
97
2023-04-01
891
187
237
184
2023-05-01
581
719
338
309
2023-06-01
860
914
454
907
2023-07-01
255
723
276
727
2023-08-01
616
467
333
144
2023-09-01
936
602
786
572
2023-10-01
593
159
457
653
2023-11-01
211
594
646
928
2023-12-01
990
288
971
944
2024-01-01
721
767
321
445
2024-02-01
70
985
539
385
2024-03-01
504
845
980
711
2024-04-01
127
474
384
581
2024-05-01
502
950
50
977
2024-06-01
100
614
666
378
2024-07-01
501
247
63
952
2024-08-01
320
547
923
927
2024-09-01
840
317
171
411
2024-10-01
881
609
507
397
2024-11-01
425
760
304
464
2024-12-01
288
467
208
526
2025-01-01
64
908
752
173
2025-02-01
618
867
599
372
2025-03-01
174
156
939
699
2025-04-01
729
847
726
905
2025-05-01
541
279
557
356
2025-06-01
655
747
718
0
2025-07-01
925
216
232
906
2025-08-01
459
771
949
14
2025-09-01
211
728
736
683
2025-10-01
479
100
977
972
2025-11-01
772
104
861
706
2025-12-01
334
894
367
392
First
3
First 3
Warn
Skip
3
Skip 1st 3
Warn
"Value"
True
True
True
False
False
False
False
False
False
upper
,
C:\ProgramData\Alteryx\Engine\Engine_24364_c1f87d661e6e45a8826ba00cf8401492_\Engine_28004_01aac848d29d4b5a9502537d5926beaf_.yxdb
Single
Profil
Horizontal
Défi 4