C:\Users\aandriani\Documents\Learning\Weekly Challenges\Intermediate\WC 146\StoreData.yxdb
StoreData.yxdb
[numReviews] >= 10 AND [stock] = "Available" AND [customerRating] >= 4
Custom
>=
numReviews
True
fixed
2019-07-28 14:16:47
0
10
2019-07-28 14:16:47
2019-07-28 14:16:47
[numReviews] >= 10 AND [stock] = "Available" AND [customerRating] >= 4
Contains([categoryPath],"Kid") OR
Contains([categoryPath],"Baby") OR
Contains([categoryPath],"Boy") OR
Contains([categoryPath],"Girl") OR
Contains([categoryPath],"Children") OR
!IsEmpty([age]) AND
!Contains([age],"Up") AND
!Contains([age],"All") AND
!Contains([categoryPath],"Beauty") AND
!Contains([categoryPath],"Shaving")
Custom
Contains
categoryPath
True
fixed
2019-07-28 14:52:28
0
KId
2019-07-28 14:52:28
2019-07-28 14:52:28
Contains([categoryPath],"Kid") OR
Contains([categoryPath],"Baby") OR
Contains([c...
Category = IF Contains([categoryPath],"Clothing")
THEN "Clothing"
ELSE "Hygeine"...
Error
Purchase Quantity
New Field
Int32
4
Empty
IF [Row-1:Amount Remaining] < 0
THEN 0
ELSEIF [Amount Remaining] < 0
THEN FLOOR((([Purchase Quantity]*[salePrice])+[Amount Remaining])/[salePrice])
ELSE [Purchase Quantity]
ENDIF
IF [Row-1:Amount Remaining] < 0
THEN 0
ELSEIF [Amount Remaini...
[Category] = "Clothing"
Simple
=
Category
True
fixed
2019-07-28 16:38:43
0
2019-07-28 16:38:43
2019-07-28 16:38:43
Clothing
[Category] = "Clothing"
Purchase Quantity
New Field
Int32
4
Empty
IF [Row-1:Amount Remaining] < 0
THEN 0
ELSEIF [Amount Remaining] < 0
THEN FLOOR((([Purchase Quantity]*[salePrice])+[Amount Remaining])/[salePrice])
ELSE [Purchase Quantity]
ENDIF
IF [Row-1:Amount Remaining] < 0
THEN 0
ELSEIF [Amount Remaini...
salePrice - Descending
salePrice - Ascending
Warning
All
ByName
C:\ProgramData\Alteryx\Engine\Engine_16176_383a68393e94429daf193bc0f73831b2_\Engine_21120_882a36705f454b02801ecf229ef0f454_.yxdb
Single
Profile
Horizontal
challenge_146_TonyA