KNOWLEDGE BASE

Get Row Numbers of Data Source in Tableau Prep Builder


Published: 18 Aug 2020
Last Modified Date: 18 Aug 2020

Question

How to get the row number (Row ID) of a data source under some order conditions.

Environment

  • Tableau Prep 2020.1.3 or later version

Answer

Create a Calculation field using ORDERBY and ROW_NUMBER functions such as:
{ ORDERBY [Order ID]:ROW_NUMBER()}
OR
{ ORDERBY [Order Date] ASC:ROW_NUMBER()}

- See attached video and flow file. 
Did this article resolve the issue?