Test Capability filter using SQL Expression in Join Recipe

FarahAmirah

Hi, I got this dataset tx and cards_prepared dataset from your Dataiku Academy

https://academy.dataiku.com/path/core-designer/visual-recipes-overview-1/500697

I’m doing it by starting from scratch.

I'm using filter in join recipe using SQL Expression using a default one;

"purchase_date" LIKE CONCAT('%', REPLACE(REPLACE(REPLACE('2017-01', '\', '\\'), '%', '\%'), '_', '\_'), '%')

I got an error

I also change SQL expression "purchase_date" LIKE '%2017-01%'

but I got an error

can you help?

---

Operating system used: Almalinux (8.9)