Returns the least common multiple shared by the first and second arguments.
Each argument can be a literal Integer number, a function returning an Integer, or a reference to a column containing Integer values.
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
lcm(10,4)
Output: Returns the least common multiple between values 10
and 4
, which is 20
.
lcm(value1, value2)
Argument | Required? | Data Type | Description |
---|---|---|---|
value1 | Y | string | The first value must be an Integer literal, column reference, or expression that evaluates to an Integer value. |
value2 | Y | string | The first value must be an Integer literal, column reference, or expression that evaluates to an Integer value. |
For more information on syntax standards, see Language Documentation Syntax Notes.
Integer expressions, column references or literals to multiply together.
Missing or mismatched values generate missing string results.
Usage Notes:
Required? | Data Type | Example Value |
---|---|---|
Yes | Literal, function, or column reference returning an Integer value | 15 |
Dica
For additional examples, see Common Tasks.
Source:
string | repeat_count |
---|---|
ha | 0 |
ha | 1 |
ha | 1.5 |
ha | 2 |
ha | -2 |
Transformation:
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | repeat(string, repeat_count) |
Parameter: New column name | 'repeat_string' |
Results:
string | repeat_count | repeat_string |
---|---|---|
ha | 0 | |
ha | 1 | ha |
ha | 1.5 | |
ha | 2 | haha |
ha | -2 |