Split to Columns Transform (November '21 Release)

With this Release we have added a new transform in the Data Connectors framework.

Now, when creating a Connector you can apply the ‘Split to Column’ transform. This will allow you to split data from one cell to two or more columns on an optional delimiter when uploading data into their Knowledge Graph.

To do this:

  1. Click Add Transform in the sidebar of the Connector configuration screen
  2. Select Split to Column from the list of available Transforms.
  3. Select the column from your dataset that you would like to pull the data from.
  4. In the New Column field, you will enter the name of the new column you would like to create. You can also click Add Column to split the data further.
  5. Enter your Delimiter.
  6. Click Apply.

You can learn more about Transforms, and the other transforms that are available with Connectors in the Transforms training unit.