Field1
String
65001
GET
Compose
2
600
DownloadData
Number = ToNumber(Right([JSON_Name], 1))
Ingredient = IF Contains([JSON_Name], "...
!IsEmpty([JSON_ValueString])
AND
(
CONTAINS([JSON_Name], "strMeasure")
OR
CONTAINS([JSON_Name], "stringredient")
)
Custom
IsNotEmpty
JSON_ValueString
True
fixed
2019-09-16 18:03:12
0
2019-09-16 18:03:12
2019-09-16 18:03:12
!IsEmpty([JSON_ValueString])
AND
(
CONTAINS([JSON_Name], "strMeasure")
OR
CONTAI...
C:\ProgramData\Alteryx\Engine\Engine_29340_c02372bef53549868a6c1d801b657935_\Engine_16648_a9305763f9fc4d10bc3b38fbc3d095e1_.yxdb
Single
Profile
Download
parse JSON field
keep only ingredients and measures
parse out number of ingredient
group by ingredient number
remove grouping field
https://www.thecocktaildb.com/api/json/v1/1/search.php?s=Old Fashioned
Solution
Bourbon
4.5 cL
Angostura bitters
2 dashes
Sugar
1 cube
Water
dash
C:\ProgramData\Alteryx\Engine\Engine_29340_c02372bef53549868a6c1d801b657935_\Engine_16648_c30371df0d244ec0bdc46c2845fd467a_.yxdb
Single
Profile
Horizontal
challenge_181_solution_rsc