---
title: Top K Values
description: Return the nth number of top values for a column
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Top K Values

## Return the nth number of top values for a column

 Function:

Top_Values(table = string, col = string, num_values = integer, new_table_name = string)

Parameters:

Table: Table name on which to perform function

col: Column for which to return the top

num_values: The number of rows to return for with top values. For example if you want the top 5 values then input the number 5

new_table_name: The name of the new table with the nth number of top values

Examples:

Top_Values(table = Budget, col = Amount, num_values = 10, new_table_name = Top_values_Budget)