Skip to main content

Stack Tool ⭐️

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

Updated over 10 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?