Test Capability filter using SQL Expression in Join Recipe

FarahAmirah
Level 1
Test Capability filter using SQL Expression in Join Recipe

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

4.PNG

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

but I got an error

3.PNG

 

can you help?


Operating system used: Almalinux (8.9)

0 Kudos
0 Replies