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
    Β·
    Β·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • 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: