Miscellaneous

change date/time pointer of a variable: $changedate

change length of column: $changelen

close to (is one value close to another): $withinPct

create multiple new columns, each containing only 0s and 1s, coding whether the input had a certain value or range: $encode, $strcode

date/time pointer, change: $changedate

difference between two rows: $delta, $differs

extract a subset of a column: $subCol

length of column, change :$changelen

lookup value by row number: $lookup, $lookupRel

near (is one value near another): $withinPct

nested if: $findle

order, find without sorting: $rank

order, sort into: $sort

previous result in a recursive definition: $prev, $prev2

random numbers: $rand, $randS, $random, $randomS

row number, current: $row

rows, count the number of: $nRows, $nValid

sort into order: $sort

sorting, find order without: $rank

subset of a column: $subCol

time merge: $timeMerge, $tMerge

valid points, number found within a moving window: $moveValid