Snickers
45318373
Candy Corn
45214366
Tootsie Roll Pop
45157442
Sweetarts
45262886
Atomic Fireballs
45213587
Chewy Sours
45245489
Sour Patch Kids
45164706
NDB Lookup
Sour Patch Kids 3, Snickers 15, Atomic Fireballs 15, Candy Corn 30, Sweetarts 25
Bag
URL
String
65001
GET
Compose
2
600
&
URL = "https://api.nal.usda.gov/ndb/V2/reports?" + [Concat_Request] + "&type=b&f...
DownloadData
Bag
Candy = Trim(Left([Bag], STRCSPN([Bag], "0123456789")))
Count = ToNumber(Right([...
Concat_Request
Values
V_String
200
Empty
IF CONTAINS([JSON_Name], "desc.ndbno") THEN
[JSON_ValueString]
ELSEIF CONTAINS([Row-1:JSON_ValueString], "kcal") THEN
[JSON_ValueString]
ELSE
Null()
ENDIF
IF CONTAINS([JSON_Name], "desc.ndbno") THEN
[JSON_ValueStrin...
!IsNull([Values])
Simple
IsNotNull
Values
True
fixed
2019-01-27 17:27:54
0
2019-01-27 17:27:54
2019-01-27 17:27:54
!IsNull([Values])
2
C:\ProgramData\Alteryx\Engine\Engine_6600_6d5ac3fae2fa40e296f9fc530e4ffe82_\Engine_10284_ae81f3c919a942688eb4f68d868e76a4_.yxdb
Horizontal
challenge_139_solution_rsc