Clay Icon

Troubleshooting API Key Issues for Table Lookup in Other Table

ยท
ยท

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.

  • Avatar of Kam
    Kam
    ยท
    ยท

    Man, this bot is amazing! I've got it sorted now! Thank you!

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    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

  • Avatar of Kam
    Kam
    ยท
    ยท

    Hi Daniel K., Quick question but is there a way to look at multiple columns in another table? I have two tables with companies and I want to match them to another table using domain AND city or domain AND zip code

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    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! :)

  • Avatar of Kam
    Kam
    ยท
    ยท

    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?

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    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!

  • Avatar of Kam
    Kam
    ยท
    ยท

    Hi Tanvi, I found a workaround by running individual values and then creating a formula to AND/OR them. Thank you!

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    That's great Kam! Let us know if there's anything else we can help you with :)

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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