You can get the length (i.e. the number of characters) of your columns using this syntax
[column].str.lengths()Configuration
The Text Column tool consists of two required input.1
Input Column Name
The Text Column tool will create a new column. Use this input to name it.
You can overwrite existing columns simple by inputting an existing column name. Check out the last example below.
2
Input Column
Input how you want to create your new column and/or what it should contain. Remember to use double-quotes around text values.
Start typing a column name to reference it - for example firstName
When To Use
There are tons of use cases for the Text Column tool. This tool is your go-to whenever you need to create some custom text columns.- You have two (or more) columns that you would like to concatenate
- To add prefixes or suffixes to your columns
- Creating fixed values - maybe you just need to create a new column with a fixed value, like a reference date
Examples
A Static Column
A Static Column
I just want to create column with the value 
something throughout my datasetCombining First and Last Name
Combining First and Last Name
I want to combine my first name and last name column to create a full name column. I want to add a space between the first and last name.
Adding a Prefix
Adding a Prefix
I want to add a prefix to my purchase IDs so that I can Combine it with my ERP data. I also want to overwrite my existing purchaseID column.