Cascade Library
  • Introduction
    • Welcome to Cascade
    • Workspaces
  • Getting Started
    • Build Your First Workflow
    • Build Your First Data App
  • Workflows
    • Overview
      • Navigating the Canvas
      • Setting Up
      • Drag and Drop
      • Tools
    • Dynamic Workflows
    • Global Variables
    • Data Locker
    • Scheduling
    • Webhooks
    • Run Logs
    • Workflow Deployment
  • Integrations
    • Connecting Cascade to your database
    • Amazon S3
    • Azure Blob Storage
    • BigQuery
    • Google Sheets
    • MySQL
    • Postgres
    • Redshift
    • SQL Server
    • Snowflake
    • Tableau Server
  • Tools
    • Import
      • Import File
      • Import from Data Locker
      • Import from API
      • Import Sample Data
      • New Table
    • Clean
      • Validate Schema
      • Find/Replace
      • Text to Columns
      • Flatten Json
      • Sample
      • Standardize
      • Validate
    • Transform
      • Edit Columns
      • Select Columns
      • Filter
      • Sort
      • Pivot
      • Unpivot
      • Deduplicate
    • Merge
      • Append
      • Join
      • Multi Join
      • Fuzzy Join
    • Predictive Modeling
      • Build Model
      • Apply Model
      • Correlate
      • ARIMA Forecast
    • Flow
      • Conditional
    • Code
      • Python
      • SQL
    • Visualize
      • Chart
        • Bar
        • Line
        • Combo
        • Scatter
        • Histogram
        • Box
        • Pie
        • Area
        • Funnel
    • Publish
      • Publish to Data Locker
      • Publish via Email
      • Publish to URL
      • Embed
  • Functions & Expressions
    • Functions
      • Aggregate Functions
        • AVERAGE
        • CORR
        • COUNT
        • COUNTD
        • COUNTBY
        • COUNTIF
        • COUNTIFS
        • COVAR
        • COVARP
        • COVARS
        • MAX
        • MEDIAN
        • MIN
        • MAXBY
        • MINBY
        • PERCENTILE
        • STDEV
        • STDEVP
        • STDEVS
        • SUM
        • SUMBY
        • SUMIF
        • VAR
        • VARP
        • VARS
        • RUNNINGTOTALBY
          • SIGN
          • SIN
          • SQRT
          • SQUARE
          • TAN
          • ZN
      • Conversion Functions
        • TIMESTAMPTODATE
        • TODATE
        • TODECIMAL
        • TOINT
      • Date/Time Functions
        • DATEADD
        • DATEDIF
        • DATENAME
        • DATENORMALIZE
        • DATEPART
        • DATETRUNC
        • DAY
        • DAYS
        • HOUR
        • ISDATE
        • ISOWEEKDAY
        • ISOWEEK
        • ISOQUARTER
        • ISOYEAR
        • MAKEDATE
        • MAKEDATETIME
        • MINUTE
        • MONTH
        • NOW
        • QUARTER
        • SECOND
        • TODAY
        • WEEK
        • WEEKDAY
        • YEAR
      • Logical Functions
        • AND
        • BETWEEN
        • CASE
        • CHOOSE
        • CONTAINSWITHIN
        • IF
        • IFS
        • IIF
        • IN
        • IFNULL
        • ISBOOLEAN
        • ISDECIMAL
        • ISDURATION
        • ISINTEGER
        • ISNULL
        • ISNUMBER
        • ISSTRING
        • ISUNIQUE
        • NOT
        • NULL
        • OR
        • SWITCH
        • ALL
          • TOSTRING
        • ANY
      • Math Functions
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEILING
        • COS
        • COT
        • COSEC
        • DEGREES
        • DIV
        • EVEN
        • EXPONENTIAL
        • FILLINFINITY
        • FLOOR
        • HAVERSINE
        • LOG
        • LN
        • ODD
        • MODULO
        • PERCENTILEOFVALUE
        • PERCENTILEVALUE
        • PI
        • POWER
        • RADIANS
        • RANDOM
        • ROUND
        • SEC
      • Table Functions
        • ENCODE
        • INDEX
        • INDEXBY
        • FILLNULL
        • FIRSTBY
        • GENERATEUNIQUEID
        • LASTBY
        • LOOKUP
        • MATCH
        • NTH
        • OFFSET
        • OFFSETBY
        • PREVIOUSVALUE
        • RANK
        • RANKBY
        • RECORDID
        • ROLLINGAVERAGE
        • ROW
        • RUNNINGAVERAGE
        • RUNNINGMAX
        • RUNNINGMIN
        • RUNNINGSTDEV
        • RUNNINGTOTAL
        • WINDOWAVERAGE
        • WINDOWMAX
        • WINDOWMIN
        • WINDOWCOUNT
        • WINDOWSUM
        • SEQUENCE
        • WINDOWMEDIAN
        • WINDOWSTDEV
        • WINDOWSTDEVP
        • WINDOWSTDEVS
        • WINDOWVAR
        • WINDOWVARP
        • WINDOWVARS
        • WINDOWCORR
        • WINDOWCOVAR
        • WINDOWCOVARP
        • WINDOWCOVARS
        • SMOOTHEDAVERAGE
      • Text Functions
        • ASCII
        • CHAR
        • CONCAT
        • CONTAINS
        • ENDSWITH
        • FIND
        • FINDNTH
        • ISEMPTY
        • JSONPARSE
        • LEFT
        • LENGTH
        • LOWER
        • LTRIM
        • MID
        • PROPER
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STARTSWITH
        • TRIM
        • SUBSTITUTE
        • UPPER
    • Building Expressions
      • Expression Operators
      • Guide to Window Functions
  • Cascade FAQs
    • Best Practices
      • 💬How to add a total row to a table
      • 💬How to leave comments on a workflow
      • 💬How to add new columns in the Edit Columns tool
      • 💬Setting up a New Table tool
      • 💬How to rename a tool
    • Knowledge Based
      • 💬How to change Data Types in Cascade
      • 💬How to remove columns from a table in Cascade
      • 💬How to rename columns in Cascade
      • 💬Understanding the Join options in the Cascade Join tool
      • 💬How to connect tools to each other
    • Import
      • 💬How to Import an Excel File into Cascade
      • 💬How to Import a CSV File into Cascade
      • 💬How to import a CSV file into the Data Locker
    • Functions and Expressions
      • 💬How to write an IN() statement with multiple variables
      • 💬How to Remove null Records with a Filter tool
      • 💬How to write an IF Statement in Cascade
      • 💬How to replace null values with 0
    • Troubleshooting
      • ⚠️What does it mean if my workflow won’t load?
      • ⚠️Why can’t I connect my tool to other tools?
      • ⚠️Why are there duplicate records after my Join tool?
  • Change Log
On this page
  • Related Questions
  • Other Sources

Was this helpful?

  1. Cascade FAQs
  2. Knowledge Based

How to change Data Types in Cascade

Easily change data types in Cascade

PreviousKnowledge BasedNextHow to remove columns from a table in Cascade

Last updated 2 years ago

Was this helpful?

Having the correct data types assigned to individual columns is paramount when working with certain tools and expressions in Cascade. For instance, the tool only allows users to join on columns with the same data type. Additionally, math expressions necessitate that the columns be in a numeric data type. Fortunately, the tool in the Cascade tool suite makes it effortless for you to modify the data type of individual columns.

The configuration of the tool permits users to select a column from the table, and edit the column name, data type, format, and description of that column. With just a few clicks, one can swiftly and easily adjust the data type of their columns, allowing them to get back to their work with a minimum of fuss. This makes the tool an invaluable part of the Cascade toolkit that allows users to ensure that the correct data types are assigned to the appropriate columns.

To select a column, utilize the column navigation arrows at the top-left corner of the tool configuration, or click the header of the column you desire to configure.

Related Questions

What is the best way to change data types in Cascade?
How do I modify the data type of my columns in Cascade?
What are the benefits of using the Edit Columns tool in Cascade?
What tools are available in Cascade to help with changing data types?
What is the importance of assigning the correct data types to columns in Cascade?

Other Sources

The tool in the Cascade tool suite is an excellent way to quickly and easily adjust the data type of individual columns. It allows users to select a column from the table, and edit the column name, data type, format, and description of that column. This makes it effortless for users to ensure that the correct data types are assigned to the appropriate columns.

The tool in the Cascade tool suite makes it easy to modify the data type of individual columns. You can select a column from the table, and edit the column name, data type, format, and description of that column. This allows you to swiftly and easily adjust the data type of your columns, so you can get back to your work with a minimum of fuss.

The tool in the Cascade tool suite provides several benefits to users. It makes it easy to modify the data type of individual columns, allowing users to swiftly and easily adjust the data type of their columns, so they can get back to their work with a minimum of fuss.

Additionally, having the correct data types assigned to individual columns is paramount when working with certain tools and functions in Cascade. For instance, the tool only allows users to join on columns with the same data type. Additionally, math functions necessitate that the columns be in a numeric data type. The tool helps users to ensure that the correct data types are assigned to the appropriate columns.

The tool in the Cascade tool suite is an excellent tool for quickly and easily adjusting the data type of individual columns. It allows users to select a column from the table, and edit the column name, data type, format, and description of that column. This makes it effortless for users to ensure that the correct data types are assigned to the appropriate columns.

Having the correct data types assigned to individual columns is essential when working with certain tools and functions in Cascade. For instance, the tool only allows users to join on columns with the same data type. Additionally, math functions necessitate that the columns be in a numeric data type. The tool in Cascade helps users to ensure that the correct data types are assigned to the appropriate columns.

💬
Edit Columns
Edit Columns
Edit Columns
Join
Edit Columns
Edit Columns
Join
Edit Columns
Edit Columns
Join
Edit Columns
Edit Columns
Edit Columns
Add an Edit Columns tool to your workflow to change assigned data types
Add an tool to your workflow to change assigned data types
Tool configuration of an Edit Columns tool and the data type menu dropdown
Tool configuration of an tool and the data type menu dropdown
Edit Columns
Edit Columns