---
title: Compare Columns
description: Logic compare over two columns (=,>,<,...)
---

[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)

# Compare Columns

## Logic compare over two columns (=,>,<,...)

***Function:***

Compare_Columns(table = string, first_col = string, second_col = string, comparison_type = string, new_col = string)

 

***Parameters:***

*Table: *Table name on which to perform function

*First Column:* 1st in the compare operation

*Second Column:* 2nd in the compare operation

*Comparison Type: *What to compare by (=,<,>,<>,!=,<=,>=)

*New Column Name:* Name of new column created

 

***Examples:***

Compare_Columns(table = Budget, first_col = "Jan", second_col = "Feb", comparison_type = "<", new_col = "Q1Compare")