LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Table Creation

Create a Combined Table

Creates a combined table from two or more existing tables.

Overview

This procedure creates a combined table from two or more existing tables.

Input Concepts

Concept
Type
Description
Default
Required

first table

table

The first table to be combined.

No default

Either tables or first table and second table are required.

second table

table

The second table to be combined.

No default

Either tables or first table and second table are required.

tables

list of tables

A list of tables to be combined.

No default

Either tables or first table and second table are required.

excluded columns

list of strings

A list of column names to be excluded from the combined table.

No default

No

included columns

dictionary

A dictionary specifying which columns to include from each table. The keys are table names, and the values are lists of column names to include.

No default

No

same columns

list of strings

A list of column names that are the same across all tables and should be combined into a single column in the combined table.

No default

No

Output Concepts

Concept
Description

table

A combined table created from the specified tables, with considerations for excluded and included columns, as well as columns that are the same across tables.

Examples

1. Create a Combined Table From the Tables

create a combined table with
    the tables

2. Create a Combined Table From the First and Second Tables

create a combined table with
    the first table
    the second table
    the excluded columns are "ID", "Timestamp"
    the same columns are "Name", "Email"

Last updated 23 days ago

Was this helpful?