1. Home
  2. Knowledge Base
  3. Working with Data
  4. [Desktop] How to use the Combine Block to Union or Merge data sets

Next >>

<< Prev

How to use the Combine Block tutorial transcript

To combine datasets:

Step 1. Select Combine Block from the Block Library and drag and drop it onto the Main Canvas.
Step 2. Connect input data to the input stubs of the Combine Block (2 or more). Be sure to check column names. It is possible to include either columns that are common across all inputs, or to include all columns. If all columns are included, then rows that come from input datasets but which don’t have a given column will be included, with _NULL_ values in that column.
Step 3. Check settings.
Step 4. Click on the output stub of the Combine Block, and use Data Viewer to ensure your datasets are combined correctly.

Contents:

  • Combine Block input data
  • Combine Block settings

Related Materials:

Transcript – How to use the Combine Block

Other resources:

Tutorial 3: How to perform calculations and transformations on your data.

Documentation: Combine Block

Length:

1:12

You can download a free trial of Analytics Canvas to follow along with the video.

Back to more Support    |   Try Analytics Canvas for Free

Was this article helpful?

Related Tutorials/Video