Clay Icon
Join the Community
02 Support

How to Remove Swiss 5-star Hotels from CSV File

Avatar of Augustin R.Augustin R.
·
·

Hey guys, I have table A with hotel names. I have a CSV file with all the swiss 5* hotels. How can I eliminate all the rows that have swiss 5* hotels from my CSV file? thanks

7 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Agustin, thanks for getting in touch! The Lookup Record integration can help with that. Here's a video and our docs page for Lookup Record!

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    But you will need to upoad the csv and clean it in a clay table

  • Avatar of Augustin R.
    Augustin R.
    ·
    ·

    Thanks I'll check that!

  • Avatar of Augustin R.
    Augustin R.
    ·
    ·

    But I want to delete the rows that match between the two tables.

  • Avatar of Augustin R.
    Augustin R.
    ·
    ·

    Any idea Juan P.?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Once you have all the matched cells you can delete them, just filter for all the rows that contain the match and delete them

    bb97ff57-6f0f-4007-9c17-a60c466a7faa.png(75 kB)
  • Avatar of Augustin R.
    Augustin R.
    ·
    ·

    Worked perfect thanks!