AzureKusto icon indicating copy to clipboard operation
AzureKusto copied to clipboard

Add support for row_number()

Open hongooi73 opened this issue 6 years ago • 1 comments

hongooi73 avatar May 23 '19 00:05 hongooi73

There's a good workaround for this, you can express it using the Kusto syntax within a mutate expression

mutate(rn = row_number(1, prev(group) != group))

gets translated to

| extend ['rn'] = row_number(1, prev(['group']) != ['group'])

You just have to make sure to do this after an arrange call because row_number in Kusto only works on sorted data.

alexkyllo avatar Aug 01 '19 17:08 alexkyllo