I'm trying to perform a match of 2 columns but without success. I have one `DF1` with 2 columns, `Id` and `JSON`. In the second `DF2`, I have one column with a pattern to be matched in each row for `DF1$json` (something like vlookup + like function).

As an output, I'd like to get `DF1$Id` but only where any of `DF2` is matched with `DF1$json`.

[![enter image description here](https://i.stack.imgur.com/v3QQW.png)](https://i.stack.imgur.com/v3QQW.png)

I've tried some combinations with `str_detect` but it doesn't work on non-vector values. Maybe some tricks with `grep` or `stringr` functions?

For example:

```
str_detect(DF1$json, fixed(DF2[1,1], ignore_case = TRUE))

```