Returns the least common multiple shared by the first and second arguments.

lcm(10,4)

Output: Returns the least common multiple between values 10 and 4, which is 20

lcm(value1, value2)


ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer literal, column reference, or expression that evaluates to an Integer value.
value2YstringThe first value must be an Integer literal, column reference, or expression that evaluates to an Integer value.

value1, value2

Integer expressions, column references or literals to multiply together.

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer value15


Example - Basic LCM function

Source:

stringrepeat_count
ha0
ha1
ha1.5
ha2
ha-2


Transformation:

Results:

stringrepeat_countrepeat_string
ha0 
ha1ha
ha1.5 
ha2haha
ha-2