Comments
-
I went the harder way and learned myself a little bit of SQL Dataflow My solution was using this SELECT *, CASE WHEN `caption` LIKE '%ball%' THEN ‘ball’ WHEN `caption` LIKE '%food %' THEN ‘food’ ELSE ‘ ‘ END as `products` FROM text I think yours is easier to learn and implement. Thankyou @ilikenno!
