Loading

Get Row Numbers of Data Source in Tableau Prep Builder

Date de publication: Apr 30, 2025
Tâche

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

Étapes
In Tableau Prep versions 2023.1 or newer, you can leverage the Source Row Number for Excel and Text files. See Add the Source Row Number field to your flow for more information.

If using an older version of Tableau Prep Builder, use the workaround below.

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. 
Numéro d’article de la base de connaissances

001453827

Pièces jointes

Get Row ID Flow.tflx

933 KB

 
Chargement
Salesforce Help | Article