Comparison

Compare two values to using a compare operator (>,<,=,>=,<=,<> or !=)

Function:

Comparison(Table = string, first_column = string, second_column = string, comparison_type = drop_down, new_col = string)

 

Parameters:

Table: Table name on which to perform function

First Column: First column name you want to compare

Second Column: Second column name you want to compare

New Column Name: Name for new column

Compare Type: Select the operator for the compare

 

Examples:

Comparison(Table = Budget, first_column = "Plan", second_column = "Actuals", comparison_type = ">", new_col = "Plan v Actuals")