Loading

Get Row Numbers of Data Source in Tableau Prep Builder

Publiceringsdatum: Apr 30, 2025
Uppgift

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

Steg
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-artikelnummer

001453827

Bilagor

Get Row ID Flow.tflx

933 KB

 
Laddar
Salesforce Help | Article