Loading

Get Row Numbers of Data Source in Tableau Prep Builder

Julkaisupäivä: Apr 30, 2025
Tehtävä

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

Vaiheet
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. 
Knowledge-artikkelin numero

001453827

Liitteet

Get Row ID Flow.tflx

933 KB

 
Ladataan
Salesforce Help | Article