Bruno V.

Actually, do you see this as a best practice in any way? I mean, instead of leaving the HTML reading and enrichment to Claygent, would you say it's better to store the HTML in a new column and ask the AI to extract info from it directly, to save some tokens?

Hi Andrew Q., thanks so much for looking into this! I'm assuming that's the website's HTML, and the cell size limit for HTTP requests is 200 kB. Is that right? Do I have to pay for these requests?

Hey Ariana (.! List B can live in Clay. I can't send you a video since I don't have a use case yet, but the message above is exactly what I need. For example:

It's basically a VLOOKUP: for each work category in List A, look it up in List B. If it exists, keep it in workCategoriesV2. If it doesn't, drop it. Does that make sense?

Ariana (., I have a quick follow-up question here. I have this workCategories column with "Category A|Category B|Category C". It doesn't have to be in this format, by the way. Let's call this "List A". Now, let's say I have a "master list" with "Category A|Category D|Category E". It could be stored somewhere else, either in Clay or in a different format. Let's call it "List B". Is it possible to merge them, like an INNER JOIN between List A and List B, so the final output is just "Category A"? Do you get what I mean? The thing is, I need to make sure the final list comes from List A, but it should only include work categories that also exist in List B. If List A contains any work category that's not in List B, it should be discarded. Is that something we can achieve with formulas?

Hey Sayli G.! Just checking in. Does this request make sense?

Hi Ariana (.! That worked perfectly. Thank you so much!

Table Column > workCategoriesRawAi

I couldn't find the "Combine items into one text field" option in my case. I'd like support from a human.