• For positive values, this function returns 1.
• For negative values, this function returns -1.
• For the value 0, this function returns 0.

Column reference example:

Output: Returns the sign of the value found in the MyInteger column.

Numeric literal example:

Output: Returns true if the sign of the entry in the MyInteger column is -1. 

numeric_value

Numeric literal, function returning numeric literal, or name of the column containg values the sign of which are to be computed.

• Missing input values generate missing results.
• Literal numeric values should not be quoted. Quoted values are treated as strings.
• Multiple columns and wildcards are not supported.

Example - Basic SIGN function

Source:

Your source data looks like the following, which measures coordinate distances from a fixed point on a grid:

Transformation:

You can use the following transform to derive the sign values of these columns:

Using these two columns, you can assign each set of coordinates into a quadrant. For ease of reading, the following has been broken into two separate tranformations:

Then, you can merge the two columns together:

Results: