Introduction
Product Features
Data Import
Data Wrangling
Visualization
- Types
  Pivot
  Summarize Table
  Table
  Bar
  Line
  Area
  Pie/Ring
  Radar
  Histogram
  Density Plot
  Scatter (No Aggregation)
  Scatter (With Aggregation)
  Boxplot
  Violin
  Error Bar
  Error Bar (Summarized Data)
  Map - Standard
  Map - Extension
  Map - Long/Lat
  Map - Heatmap
  Heatmap
  Contour
  Number
  Word Cloud
  Word Cloud (日本語)
- Features
  Trend Line
  Reference Line
  Repeat By
  Window Calculation
  Date/Time Aggregation
  Show Range
  Highlight
  Change Marker
  Multiple Y-Axis Columns
  Layout Configuration
  Column Configuration
  Column Configuration Dialog
  Color and Group Setting
  Color and Group Setting (日本語)
  Color Setting
  User Color Palette Setting
  Pin
  Save as PNG/SVG
  Save as Exploratory Data File
  Share/Schedule
  URL Link
  Category (Binning)
  Highlight
  Limit Values
  'Others' Group
  Edit Display Name
  Missing Value Handling
  Rename Column Names
  Axis Setting
  Axis Formatting
  Show Detail
  Fit to Screen (Table)
  Number of Unique Values Check
  Number of Unique Values Check (日本語)
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts

Powered by GitBook

On this page

How to Access This Feature
From + (plus) Button
Bind multiple data frames by row

Was this helpful?

Data Wrangling

Merge

PreviousJoin NextGather

Last updated 2 years ago

Merge multiple data frames by row.

How to Access This Feature

From + (plus) Button

Click "+" button and select "Merge (Add Rows / Union)"

Bind multiple data frames by row

Select Operation Type for the Merge. Supported options are:

Bind Rows (Merge all rows)
Union (Merge only unique rows)
Intersection (Merge only the common)
Setdiff (Merge only the difference)

Select the Data Frames you want to merge. You can select a single or multiple data frames.
(Optional) You can enable 'Reserve Data Frame Name' option to create a new column to hold the names of merged data frames.
(Optional) You can enable 'Force Data Type to Match' to merge the data frames even when the data types of the corresponding columns are different. After the merge, it detects and assigns appropriate data types automatically.