Decimal transformations in Wrangler

Description

As an ETL developer, I would like to work with decimal types in a code-free manner for most
commonly used decimal operations.

Use cases:

  • Converting into Decimal

    • Convert String to a Decimal

    • Convert Integer to a Decimal

    • Convert Long to a Decimal

    • Convert Float to a Decimal

    • Convert Double to a Decimal

    • Convert decimal to a integer

    • Convert decimal to a long

    • Convert decimal to a float

    • Convert decimal to a double

  • Transformations with Decimal

    • Move the decimal point n places to the right

    • Move the decimal point n places to the left

    • Get the nth power of a decimal

    • Strip trailing zeros in a decimal

    • Negate a decimal

    • Sign of a value

  • Cross-column operations for arithmetic

    • Get the absolute value

    • Get the precision of a decimal value

    • Get the scale of a decimal value

    • Get the unscaled value of a decimal value

    • Add two columns

    • Subtract a column from another column

    • Multiply a column with another column

    • Divide a column by another and return the quotient

    • Divide a column by another and return the remainder

    • calculate LCM of two column

    • Check if a value is equal to another column

    • Find the maximum of two columns

    • Find the minimum of two columns

       



Release Notes

None

Activity

Show:
Prerna Bellara
February 12, 2021, 10:20 AM

Assignee

Flakrim Jusufi

Reporter

Prerna Bellara

Labels

None

Dev Complete Date

None

Publish Date

None

Reviewer

None

Sprint

Cirus Sprint 5

Priority

Major