Input
Output
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 #10
The use case:
A distribution center receives a package. At the point of receipt, the package is scanned and a timestamp is captured for arrival date/time. The company is trying to reduce the amount of time the package is at its facility and as a result is trying to analyze how long packages remain at the facility.
The objective for this exercise is to calculate the delta between arrival date/time and the Time_Now field (this field has the date/time of the creation of this exercise and will be changing as time goes on). Create a unique field for Days, Hours, Minutes and Seconds.
HPNZGSDMQMX
2014-07-09 11:07:47
2014-07-14 08:24:35
F5NZRZ3YVRD
2014-07-09 08:40:07
2014-07-14 08:24:35
FHNBTNMV3MP
2014-07-08 12:26:56
2014-07-14 08:24:35
ZHN7W97Z955
2014-07-08 13:26:38
2014-07-14 08:24:35
ZKNWRVBTXZ2
2014-07-08 13:25:42
2014-07-14 08:24:35
HGNYD3V77CQ
2014-07-07 19:13:24
2014-07-14 08:24:35
HJN6JRBWR3Z
2014-07-08 11:39:52
2014-07-14 08:24:35
KNNHPH2YTPX
2014-07-07 14:35:10
2014-07-14 08:24:35
JPNX3YQ5GV3
2014-07-08 10:35:18
2014-07-14 08:24:35
ZFN8QQ3RSP7
2014-07-07 20:00:46
2014-07-14 08:24:35
ZFN8QQ3RSP7
2014-07-09 13:31:24
2014-07-14 08:24:35
GTNVDYQPLXT
2014-07-08 13:26:46
2014-07-14 08:24:35
ZPNZYQRYRP9
2014-07-07 14:13:24
2014-07-14 08:24:35
N5N8T5CKSXY
2014-07-07 17:06:37
2014-07-14 08:24:35
HNNDMTZHK7R
2014-07-08 13:01:44
2014-07-14 08:24:35
ZDNF7FBYH54
2014-07-08 08:41:20
2014-07-14 08:24:35
N9NJ275XPMZ
2014-07-09 11:21:16
2014-07-14 08:24:35
KMNC8ML97ZK
2014-07-07 17:10:34
2014-07-14 08:24:35
KMNC8ML97ZK
2014-07-07 17:42:25
2014-07-14 08:24:35
JYNLNB87C73
2014-07-07 14:55:58
2014-07-14 08:24:35
N4N4QCSJWQX
2014-07-07 15:48:03
2014-07-14 08:24:35
P8N4TSH8SL3
2014-07-08 16:37:45
2014-07-14 08:24:35
LHNKDQDD8G3
2014-07-07 20:01:11
2014-07-14 08:24:35
LHNKDQDD8G3
2014-07-09 13:31:40
2014-07-14 08:24:35
PJNT3NKM6F4
2014-07-07 19:45:35
2014-07-14 08:24:35
G9NNGTMNLPJ
2014-07-08 08:44:18
2014-07-14 08:24:35
G9NNGTMNLPJ
2014-07-08 16:54:40
2014-07-14 08:24:35
F2NCWKFQ5FS
2014-07-09 11:12:11
2014-07-14 08:24:35
MDNSZPY6MLY
2014-07-08 16:17:20
2014-07-14 08:24:35
K7NW774HZMJ
2014-07-07 14:15:57
2014-07-14 08:24:35
K7NW774HZMJ
2014-07-07 19:13:16
2014-07-14 08:24:35
N6ND7Z47PGT
2014-07-08 11:40:25
2014-07-14 08:24:35
N6ND7Z47PGT
2014-07-08 12:26:32
2014-07-14 08:24:35
N6ND7Z47PGT
2014-07-08 12:26:46
2014-07-14 08:24:35
Z2NJRFDVDN6
2014-07-08 10:35:28
2014-07-14 08:24:35
VWN6ZZ99L3Q
2014-07-08 14:47:01
2014-07-14 08:24:35
GMN8T99TPMR
2014-07-07 18:20:02
2014-07-14 08:24:35
NTNS4MJ672W
2014-07-07 18:06:19
2014-07-14 08:24:35
V7NLG9GJ2B9
2014-07-09 12:52:35
2014-07-14 08:24:35
LGNFMNWML96
2014-07-09 11:37:13
2014-07-14 08:24:35
NMNP8S4HMDC
2014-07-08 14:34:21
2014-07-14 08:24:35
J6NT6YM6BYF
2014-07-09 13:08:53
2014-07-14 08:24:35
VBNHT8DPRD5
2014-07-08 15:11:35
2014-07-14 08:24:35
onsite095
2014-07-09 12:54:48
2014-07-14 08:24:35
HVN9P6WBWPD
2014-07-07 17:38:41
2014-07-14 08:24:35
KMNW7B2ZXV4
2014-07-08 13:13:04
2014-07-14 08:24:35
C:\ProgramData\Alteryx\Engine\Engine_9908_c227da99b78b42b39ba3e01a4bd11c1d_\Engine_27024_a627c0098be94dd798186c3355d831e1_.yxdb
Single
Profile
HPNZGSDMQMX
2014-07-09 11:07:47
2014-07-14 08:25:16
4
21
17
29
F5NZRZ3YVRD
2014-07-09 08:40:07
2014-07-14 08:25:16
4
23
45
9
FHNBTNMV3MP
2014-07-08 12:26:56
2014-07-14 08:25:16
5
19
58
20
ZHN7W97Z955
2014-07-08 13:26:38
2014-07-14 08:25:16
5
18
58
38
ZKNWRVBTXZ2
2014-07-08 13:25:42
2014-07-14 08:25:16
5
18
59
34
HGNYD3V77CQ
2014-07-07 19:13:24
2014-07-14 08:25:16
6
13
11
52
HJN6JRBWR3Z
2014-07-08 11:39:52
2014-07-14 08:25:16
5
20
45
24
KNNHPH2YTPX
2014-07-07 14:35:10
2014-07-14 08:25:16
6
17
50
6
JPNX3YQ5GV3
2014-07-08 10:35:18
2014-07-14 08:25:16
5
21
49
58
ZFN8QQ3RSP7
2014-07-07 20:00:46
2014-07-14 08:25:16
6
12
24
30
ZFN8QQ3RSP7
2014-07-09 13:31:24
2014-07-14 08:25:16
4
18
53
52
GTNVDYQPLXT
2014-07-08 13:26:46
2014-07-14 08:25:16
5
18
58
30
ZPNZYQRYRP9
2014-07-07 14:13:24
2014-07-14 08:25:16
6
18
11
52
N5N8T5CKSXY
2014-07-07 17:06:37
2014-07-14 08:25:16
6
15
18
39
HNNDMTZHK7R
2014-07-08 13:01:44
2014-07-14 08:25:16
5
19
23
32
ZDNF7FBYH54
2014-07-08 08:41:20
2014-07-14 08:25:16
5
23
43
56
N9NJ275XPMZ
2014-07-09 11:21:16
2014-07-14 08:25:16
4
21
4
0
KMNC8ML97ZK
2014-07-07 17:10:34
2014-07-14 08:25:16
6
15
14
42
KMNC8ML97ZK
2014-07-07 17:42:25
2014-07-14 08:25:16
6
14
42
51
JYNLNB87C73
2014-07-07 14:55:58
2014-07-14 08:25:16
6
17
29
18
N4N4QCSJWQX
2014-07-07 15:48:03
2014-07-14 08:25:16
6
16
37
13
P8N4TSH8SL3
2014-07-08 16:37:45
2014-07-14 08:25:16
5
15
47
31
LHNKDQDD8G3
2014-07-07 20:01:11
2014-07-14 08:25:16
6
12
24
5
LHNKDQDD8G3
2014-07-09 13:31:40
2014-07-14 08:25:16
4
18
53
36
PJNT3NKM6F4
2014-07-07 19:45:35
2014-07-14 08:25:16
6
12
39
41
G9NNGTMNLPJ
2014-07-08 08:44:18
2014-07-14 08:25:16
5
23
40
58
G9NNGTMNLPJ
2014-07-08 16:54:40
2014-07-14 08:25:16
5
15
30
36
F2NCWKFQ5FS
2014-07-09 11:12:11
2014-07-14 08:25:16
4
21
13
5
MDNSZPY6MLY
2014-07-08 16:17:20
2014-07-14 08:25:16
5
16
7
56
K7NW774HZMJ
2014-07-07 14:15:57
2014-07-14 08:25:16
6
18
9
19
K7NW774HZMJ
2014-07-07 19:13:16
2014-07-14 08:25:16
6
13
12
0
N6ND7Z47PGT
2014-07-08 11:40:25
2014-07-14 08:25:16
5
20
44
51
N6ND7Z47PGT
2014-07-08 12:26:32
2014-07-14 08:25:16
5
19
58
44
N6ND7Z47PGT
2014-07-08 12:26:46
2014-07-14 08:25:16
5
19
58
30
Z2NJRFDVDN6
2014-07-08 10:35:28
2014-07-14 08:25:16
5
21
49
48
VWN6ZZ99L3Q
2014-07-08 14:47:01
2014-07-14 08:25:16
5
17
38
15
GMN8T99TPMR
2014-07-07 18:20:02
2014-07-14 08:25:16
6
14
5
14
NTNS4MJ672W
2014-07-07 18:06:19
2014-07-14 08:25:16
6
14
18
57
V7NLG9GJ2B9
2014-07-09 12:52:35
2014-07-14 08:25:16
4
19
32
41
LGNFMNWML96
2014-07-09 11:37:13
2014-07-14 08:25:16
4
20
48
3
NMNP8S4HMDC
2014-07-08 14:34:21
2014-07-14 08:25:16
5
17
50
55
J6NT6YM6BYF
2014-07-09 13:08:53
2014-07-14 08:25:16
4
19
16
23
VBNHT8DPRD5
2014-07-08 15:11:35
2014-07-14 08:25:16
5
17
13
41
onsite095
2014-07-09 12:54:48
2014-07-14 08:25:16
4
19
30
28
HVN9P6WBWPD
2014-07-07 17:38:41
2014-07-14 08:25:16
6
14
46
35
KMNW7B2ZXV4
2014-07-08 13:13:04
2014-07-14 08:25:16
5
19
12
12
C:\ProgramData\Alteryx\Engine\Engine_9908_c227da99b78b42b39ba3e01a4bd11c1d_\Engine_27024_177de1edb47f4f29ad6e6f143063121a_.yxdb
Single
Profile
Days = FLOOR([Test_Diff]/24/60/60)
Hours = FLOOR(((Test_Diff)- ([Days]*24*60*60)...
Test_Diff_Hours = (DateTimeDiff([Time_Now],[TIMESTAMP],'hours'))
Diff_Hours = Mo...
Test_Diff_Mins = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')
Diff_Mins = MOD(...
Test_Diff_Secs = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds')
Diff_Secs = MOD(...
Horizontal
challenge_10_solved