.\StoreData.yxdb
StoreData.yxdb
[stock] = "Available" AND [customerRating] >= 4 AND [numReviews] >= 10 AND !IsNull([FinalPrice])
Custom
!=
stock
True
fixed
2018-12-19 18:47:00
0
Not available
2018-12-19 18:47:00
2018-12-19 18:47:00
[stock] = "Available" AND [customerRating] >= 4 AND [numReviews] >= 10 AND !IsNu...
Type = IF Contains([categoryPath],"Clothing") THEN 'Clothing' ELSE 'Hygiene' END...
Error
RowCount
Int32
4
1
RowCount <= 10
RowCount + 1
[RunTot_FinalPrice] <= [Budget]
Custom
=
True
fixed
2018-12-19 20:55:38
0
2018-12-19 20:55:38
2018-12-19 20:55:38
[RunTot_FinalPrice] <= [Budget]
RowCount - Ascending
FinalPrice - Ascending
[Type] = "Clothing"
Simple
=
Type
True
fixed
2018-12-19 21:06:40
0
Clothing
2018-12-19 21:06:40
2018-12-19 21:06:40
[Type] = "Clothing"
RowCount
Int32
4
1
RowCount <= 10
RowCount + 1
[RunTot_FinalPrice] <= [Budget]
Custom
=
True
fixed
2018-12-19 20:55:38
0
2018-12-19 20:55:38
2018-12-19 20:55:38
[RunTot_FinalPrice] <= [Budget]
RowCount - Ascending
FinalPrice - Ascending
customerRating - Descending //we want only the best
customerRating - Descending
Warning
All
ByName
Basic
100%
Total
Formula
Data
==
1
IsNull([Type])
Total Rule 1
Basic Table
C:\Users\309366\AppData\Local\Temp\Engine_14164_7a85bd2913664027a4ed7915d519a7d6_\Engine_16936_d15293e6ac4043dea5e5a5eff5aff9df_.yxdb
Single
Report
count total spent
Custom
Warning
All
ManualDelayed
C:\Users\309366\AppData\Local\Temp\Engine_14164_7a85bd2913664027a4ed7915d519a7d6_\Engine_16936_007dd7641ee8419bab887321260a7d35_.yxdb
Single
Profile
Solution counter
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-146-SANTALYTICS-2018-Part-2/m-p/343664/page/
RowCount
Int32
4
1
RowCount <= 10
RowCount + 1
URL
String
65001
GET
Compose
2
600
DownloadData
REGEX_Match([DownloadData], '.+href=.+\.yxmd.+')
or
REGEX_Match([DownloadData], '.+href=.+\.yxzp.+')
Custom
=
True
fixed
2018-11-29 11:17:45
0
2018-11-29 11:17:45
2018-11-29 11:17:45
REGEX_Match([DownloadData], '.+href=.+\.yxmd.+')
or
REGEX_Match([DownloadData], ...
!Contains([DownloadHeaders],"found")
Simple
NotContains
DownloadHeaders
True
fixed
2018-11-29 11:23:48
0
found
2018-11-29 11:23:48
2018-11-29 11:23:48
!Contains([DownloadHeaders],"found")
Horizontal
challenge_146_AJ