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:
14-04-2023 10:21:37 -0400

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]( 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
You must sign in to add an answer. If you do not have an account, you can register here