Skip To Content

Cleansing multiple columns at the same time

There are often several columns that have the same data type and need the same cleanup rules applied. In the cleanse node, when you go to establish your cleanse operations, just hold the ctrl key down as you click multiple columns on the left side of the pane. Then, the rule you establish will apply to all columns once you click “add”. Remember, all the columns you multi-select have to be the same data type for this to work.

Back to Knowledge Base