How to Remove Swiss 5-star Hotels from CSV File

·

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

✅1

7 comments

· Sorted by Oldest

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!
Clay Team
APP
·
·
But you will need to upoad the csv and clean it in a clay table
Augustin R.
·
·
Thanks I'll check that!
Augustin R.
·
·
But I want to delete the rows that match between the two tables.
Augustin R.
·
·
Any idea Juan P.?
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)
Augustin R.
·
·
Worked perfect thanks!

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!
Clay Team
APP
·
·
But you will need to upoad the csv and clean it in a clay table
Augustin R.
·
·
Thanks I'll check that!
Augustin R.
·
·
But I want to delete the rows that match between the two tables.
Augustin R.
·
·
Any idea Juan P.?
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)
Augustin R.
·
·
Worked perfect thanks!