C:\Downloads\Bus Data Sample.xlsx|`Sheet1$`
False
Bus Data Sample.xlsx
Table=`Sheet1$`
Start - Ascending
End - Ascending
Preferability Score - Descending
Route=Replace([Route], "PHIL", "PHL")
Start=Left([Route],3)
End=REGEX_Replace([Route], ".*([A-Z]{3}):.*", "$1")
...
C:\ProgramData\Alteryx\Engine\Engine_4856_90868c3c22d24f45a5992f1355e44041_\Engine_10536_8228b015cc94482d8bd3449e30ea20a5_.yxdb
Route
RunningExcess
Int32
254
Empty
[Row-1:RunningExcess]+[Excess]-Min([Available],[Share of Preferability Score]*[Row-1:Excess])
[Row-1:RunningExcess]+[Excess]-Min([Available],[Share of Pref...
Route
Allocated
Int32
254
Empty
[Row-1:RunningExcess]+[Excess]-[RunningExcess]
[Row-1:RunningExcess]+[Excess]-[RunningExcess]
Horizontal
Allocate Seats Proportion