Loading

Get Row Numbers of Data Source in Tableau Prep Builder

Дата публикации: Apr 30, 2025
Задача

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

Действия
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. 
Номер статьи базы знаний

001453827

Вложения

Get Row ID Flow.tflx

933 KB

 
Загрузка
Salesforce Help | Article