Question
How to get the row number (Row ID) of a data source under some order conditions.
Last Modified Date: 18 Aug 2020
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.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials