Merge Columns in a Data Flow

You can combine multiple columns into a single column. For example, you might merge the street address, street name, state, and ZIP code columns so that they display as one item in visualizations.

Use the Merge Columns step in the data flow editor.
  1. Click Add a step (+), and select Merge Columns.
  2. Use the options on the Merge Columns pane to configure your merge:
    • (+) Column field - Select more columns you want to merge.
    • Delimiter field - Select a delimiter to separate column names (for example, Space, Comma, Dot, or Custom Delimiter).