Hi Clay S., I'm trying to lookup multiple values in Other Table but it's not letting me pick a table. My API key is added but when I go to search for table it's showing any options of the tables in my account.
Man, this bot is amazing! I've got it sorted now! Thank you!
Hi Kam! Yeah, the new bot is awesome. If there's anything else I can assist you with, please let me know! ๐ Have a great Wednesday, Daniel
Hey Kam, sure thing! :) To look up multiple columns in another table based on multiple criteria such as domain AND city or domain AND zip code, you can use the "Lookup Multiple Rows in Other Table" action in Clay. This feature allows you to retrieve multiple matching records from another table by specifying the criteria you need. For instance, you can match companies in one table with another using both domain and city or domain and zip code as your criteria. Here's how you can set it up: * Identify the ID of the table you want to search. * Use dynamic fields to specify the criteria for matching the records, such as domain and city or domain and zip code. * Run the lookup action to retrieve the matching rows from the other table. Hope this helps! :)
Hi Dan, I can only select one Target column. For example if I pick domain and then select equals and in the row value I look for domain & company name it doesn't return the same results I got when I looked for each of those values separately. Here is the table I'm running https://app.clay.com/workspaces/304869/workbooks/wb_aZVSNohcATvY/tables/t_3JJdR3h4Dn3x/views/gv_fuAoKoS8rByU Can you have a look?
Hey Kam, thank you for the additional clarification - you unfortunately cannot conduct a lookup with multiple target columns, so what you are experiencing when you add multiple columns in the row value is expected behavior. Essentially, this setup will not pull any matching results because your logic is saying that your domain column must exactly equal the domain and name row values together. There is no condition in which this is true so you will always return no matches here. Can you clarify why you want to target match these companies using domain and city/zip code instead of just domain? Because domain is a unique identifier, this should usually be enough to pull the correct company. Let me know if I'm missing anything so I can support you further!
Hi Tanvi, I found a workaround by running individual values and then creating a formula to AND/OR them. Thank you!
That's great Kam! Let us know if there's anything else we can help you with :)