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.
Thank you for providing your feedback on the effectiveness of the article.