Skip to main content
Stack Tool ⭐️

Combine multiple datasets by stacking rows to consolidate similar data into one output.

Updated over 2 months ago

About the Stack Tool

The Stack tool allows you to combine multiple datasets by stacking rows from each dataset into a single output. This tool is useful when you want to consolidate similar data from multiple sources.

Configuration Options

  1. Inputs: The Stack tool supports up to 10 datasets as inputs simultaneously. Connect the datasets to the tool to begin configuration.

  2. Fields to Include:

    • All: Includes all fields from all connected datasets in the output.

    • Matched: Only includes fields that are present in all connected datasets.

  3. Match Fields By:

    • Name: Matches fields based on their name across the datasets.

    • Position: Matches fields based on their position (column order) in the datasets.

  4. Format According To:

    • You can choose one of the input datasets as the basis for the formatting of the output fields (e.g., field types and structure).

Additional Notes

  • Field Limitations: Ensure that fields have consistent names or positions across datasets when using the Matched option to avoid mismatches.

Did this answer your question?