.png){kind=logo}
Checking for Matching Values in Unique Column and Specific Row
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
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
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
or if you think there is a better workaround lmk
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
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:)
This doesn't answer my question
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
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
Esteban L. can you send me a link to both the tables you are using currently?
Table that has the column with the technoligies separated by comma
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
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?