Dealing with duplicate columns? This particular node is designed to remove similarly named header.
If “State”=”State” then we remove the last column and only keep the first column.
“Remove duplicate columns based on similar header names”

Currently there are no settings for this tool because today Duplicate Columns Node solves problems without requiring a settings configuration.

The Duplicate Columns Node is built to automatically remove any duplicate headers.
The hardest part is connecting the dots.
Here’s the various ways you will see The Duplicate Columns node in ET1.

A Use case Duplicate Columns Node
Crazy scenario; someone is sending you tables of data with duplicate columns, and now it’s your job to clean the table. This is a great tool, which simply removes Duplicate Columns.
The data you’re reviewing has unnecessary columns that are identically named.
Learn more on the ET1 Overview landing page.