Table Steps

Transform data in PlaidCloud workflows with table steps for joins, unions, pivots, extracts, copies, and updates.
Table Anti Join

Perform an anti-join between two tables in a PlaidCloud workflow step to find unmatched records that exist in only one table.

Table Append

Append rows to an existing data table in a PlaidCloud workflow step to add new records while preserving existing table data.

Table Clear

Clear all rows from a data table in a PlaidCloud workflow step while preserving the table structure and column definitions.

Table Copy

Create a complete copy of a data table in a PlaidCloud workflow step including all rows, columns, and schema definitions.

Table Cross Join

Perform a cross join between two tables in a PlaidCloud workflow step to produce a Cartesian product of all row combinations.

Table Drop

Drop and permanently delete a data table in a PlaidCloud workflow step to remove tables that are no longer needed in your project.

Table Extract

Extract filtered data from one table into another in a PlaidCloud workflow step with column mapping and row selection options.

Table Faker

Generate synthetic test data in a PlaidCloud workflow step using Faker to create realistic sample datasets for development.

Table In-Place Delete

Delete specific rows from a table in a PlaidCloud workflow step using filter conditions to remove targeted records in place.

Table In-Place Update

Update specific rows in a table in a PlaidCloud workflow step using filter conditions and value expressions for targeted changes.

Table Inner Join

Perform an inner join between two tables in a PlaidCloud workflow step to combine matching records based on shared key columns.

Table Lookup

Perform table lookups in a PlaidCloud workflow step to enrich data by matching records and appending columns from a reference table.

Table Melt

Unpivot columns to rows in a PlaidCloud workflow step to transform wide data tables into a normalized long format structure.

Table Outer Join

Perform an outer join between two tables in a PlaidCloud workflow step to combine records and include unmatched rows from both.

Table Pivot

Pivot rows to columns in a PlaidCloud workflow step to transform long data tables into a summarized wide format structure.

Table Union All

Combine two tables using union all in a PlaidCloud workflow step to stack all rows together including any duplicate records.

Table Union Distinct

Combine two tables using union distinct in a PlaidCloud workflow step to merge rows while automatically removing duplicates.

Table Upsert

Perform an upsert operation in a PlaidCloud workflow step to update existing records or insert new ones based on key matching.