Clay Icon

Stacking Multiple Tables with Same Key Columns: Equivalent to SQL UNION

·
·

Is there a way to 'stack' multiple tables on each other if they have the same key columns? This would be the equivalent of a UNION command in SQL

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Peter, thanks for reaching out! To help, here’s an example demonstrating how to pivot data between tables using a Lookup integration. It works similarly to the VLOOKUP function in Excel: Watch the video, which should address the use case you're describing here. You can also find more details about this feature in our documentation. Let me know if you have any questions!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Peter J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: