Checking for Matching Values in Unique Column and Specific Row

Esteban L. · 2024-01-16 18:20:25.980738+00

Hey Clay! I want to see if any of the values listed within a unique column, match a column in a specific row in another table

Checking for Matching Values in Unique Column and Specific Row | Clay

12 comments

· Sorted by Oldest

Esteban L.
·
·
case: reading a column that has technology separated by comma, and I want to see if any of the values match any of the tech in another table
Loading attachments
Esteban L.
·
·
1st pic is the column that I want to check next to it, if one of those values was found in the other table is like doing lookup with each of the values into the 2nd table
Esteban L.
·
·
or if you think there is a better workaround lmk
Esteban L.
·
·
another way to see it a find keyword column that instead of filling in manually the keywords, it take it from a column in a table, not sure if that is possible, that would be great
Clay Team
APP
·
·
Hi Esteban L., happy to help:) I would recommend using the Lookup Record in Other Table enrichment. Here's a tutorial: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656Let me know if this works for you! If you have any issues implementing, feel free to send me your clay table and I'm happy to help troubleshoot:)
🙃1
Esteban L.
·
·
This doesn't answer my question
Esteban L.
·
·
I think what I need to do is find keyword over a technologies comma separed column from table A, and then see if any of the values contained in that column is found in a row for a certain column in another table find keyword over column technologies by looking at table b > technologyname column
Esteban L.
·
·
Anjali D. if you have access please refer this table What I want to do is in the latest column "Example Lookup" But I need to do this for each of the values separated by comma from the column in Row Value
Clay Team
APP
·
·
Esteban L. can you send me a link to both the tables you are using currently?
Esteban L.
·
·
Table that has the column with the technoligies separated by comma
Esteban L.
·
·
Table B that I want to read from the rows and see if any of the technologies separated by comma in Table A, is any of the technologies listed here in Table B
Clay Team
APP
·
·
Hi Esteban L., I think the Lookup Record enrichment might be having an issue with filtering through a comma separated list. What enrichment did you use to find the technologies?

Esteban L.
·
·
case: reading a column that has technology separated by comma, and I want to see if any of the values match any of the tech in another table
Loading attachments
Esteban L.
·
·
1st pic is the column that I want to check next to it, if one of those values was found in the other table is like doing lookup with each of the values into the 2nd table
Esteban L.
·
·
or if you think there is a better workaround lmk
Esteban L.
·
·
another way to see it a find keyword column that instead of filling in manually the keywords, it take it from a column in a table, not sure if that is possible, that would be great
Clay Team
APP
·
·
Hi Esteban L., happy to help:) I would recommend using the Lookup Record in Other Table enrichment. Here's a tutorial: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656Let me know if this works for you! If you have any issues implementing, feel free to send me your clay table and I'm happy to help troubleshoot:)
🙃1
Esteban L.
·
·
This doesn't answer my question
Esteban L.
·
·
I think what I need to do is find keyword over a technologies comma separed column from table A, and then see if any of the values contained in that column is found in a row for a certain column in another table find keyword over column technologies by looking at table b > technologyname column
Esteban L.
·
·
Anjali D. if you have access please refer this table What I want to do is in the latest column "Example Lookup" But I need to do this for each of the values separated by comma from the column in Row Value
Clay Team
APP
·
·
Esteban L. can you send me a link to both the tables you are using currently?
Esteban L.
·
·
Table that has the column with the technoligies separated by comma
Esteban L.
·
·
Table B that I want to read from the rows and see if any of the technologies separated by comma in Table A, is any of the technologies listed here in Table B
Clay Team
APP
·
·
Hi Esteban L., I think the Lookup Record enrichment might be having an issue with filtering through a comma separated list. What enrichment did you use to find the technologies?