Change Type

Enables changing a column to a different data type.

The results can be output as Text, Integer (Whole Number), Decimal, Date and Time, Boolean.

Date & Time must be in one of the following formats:

  • Date & Time must be in one of the following formats:

    • dd MMM yyyy HH:mm:ss.ff

      • 17 Dec 2022 20:42:32.23342

    • MM/dd/yyyy HH:mm:ss.ff

      • 12/17/2022 20:42:32.23342

    • yyyy.MM.dd HH:mm:ss.ff

      • 2022-12-17 20:42:32.23342

      • 2022-12-17T20:42:32.23342

    • The date separator can be ".", "-" or "/"

  • Integer or Decimal must be in one of the following formats:

    • #.#

      • 1656 or 1656.5689 or 1,656.5689

    • -#.#

      • -1656 or -1656.5689 or -1,656.5689

    • (#.#)

      • (1656) or (1656.5689) or (1,656.5689)

    • The decimal separator must be a period (.)

    • The thousands separator must be a comma (,)

  • Boolean must be one of the following values (case insensitive):

    • True / Yes / 1

    • False / No / 0

Last updated