A New Advanced Node to Streamline Column Clean Up

The new Clean Up Column Node provides options to clean data within selected columns - remove whitespace, letters, numbers, and more with a few clicks.

How Do You Use the Clean Up Columns Node?

Use any of the Transform buttons to open the list of nodes and type Clean to highlight all the data cleaning nodes. Make sure to select the Clean Up Columns option.

How Do You Select Fields In the Clean Up Columns Node? 

Once connected to your data, select the column you would like to clean. You can group several columns in one row that will have the same cleanup options



What Are the Clean Up Options?

Here's a list of the clean up options available and a short description for each:

  • Fill Null: Replace empty values with an empty or zero value.
  • Trim Whitespaces: Removes whitespace from the beginning and end of text.
  • Simplify Whitespaces: Replaces large whitespaces with a single space.
  • Remove Whitespaces: Gets rid of all whitespaces.
  • Remove letters.
  • Remove numbers.
  • Remove numeric symbols: Removes characters such as  ". , ( ) + - " that are often used as numerical punctuation
  • Remove punctuation: Removes special characters such as " ! " # $ % & ' * , \ . / : ; < = > ? @ [ / ] ^ _ ` { | } ~ "

You could choose one or many options from the list and the selection could be different for each column that you choose to clean.


More Data Clean Up Nodes

This node pairs great with Clean Up and Remove Empty to prep your data.