KNOWLEDGE BASE

How To Sort Data Source Using Tableau Prep


Published: 06 Apr 2022
Last Modified Date: 07 Apr 2022

Issue

How to sort data source using Tableau Prep?

Environment

  • Tableau Prep Builder

Resolution

Sorting is possible by using the RANK function.

In the following example, you want to sort the Orders sheet by sales order.
1. Connect to Sample -Superstore.
2. Drag Sheet 'Orders' canvas.
3. Add Clean Step.
4. Create a Calculated Field as following setting.
      Name : Rank
      Calculation :{ ORDERBY [Sales] DESC : RANK() }

You will see that they are sorted in descending order by Sales.

Cause

This feature is not built in Tableau Prep Builder yet.
Did this article resolve the issue?