Skip to main content
info
This documentation is for version v2.3 of the product.
For the latest version(v2.7) documentation click here
Version: v2.3 print this page

WindowRanking

Type

transform

Fields

NameTitleDescription
partitionByColsPartitionBypartition column names separated by comma(,)
orderByColsOrderByorder by column names separated by comma(,)
windowFunctionWindow FunctionWindow Function Name

Examples

Input

idpricelotsizebedroomsbathrmsstories
1420005850312
2385004000211
3495003060311
4605006650312
5610006360211
6660004160311
7660003880322

Parameters

NameValue
PartitionBybedrooms , bathrms
OrderBylotsize , price desc
Window FunctionRank

Output

idpricelotsizebedroomsbathrmsstoriesrank
76600038803221
34950030603111
66600041603112
14200058503123
46050066503124
23850040002111
56100063602112