You can translate the question and the replies:

Denodo function equivalent to Table.AddIndexColumn Power BI function

Does Denodo have a function that is equivalent to the Table.AddIndexColumn Power Query function that one can use in Power BI? See: https://learn.microsoft.com/en-us/powerquery-m/table-addindexcolumn
user
14-04-2023 10:21:37 -0400
code

1 Answer

Hi, On refering to the documentation link that you provided, we undestand that function Table.AddIndexColumn is used to add index column to the table. Denodo also has a similar function called [ROWNUM](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/other_functions/other_functions#rownum) The ROWNUM function returns a unique number for each row of the result of a query. This number is unique for each query even if the data were retrieved from different sources. The ORDER BY clause is processed after ROWNUM assigns a value to each row. For consistent results between several executions of a query, use ROWNUM() over a view with the ORDER BY clause. Hope this helps!
Denodo Team
24-04-2023 00:26:12 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here