Providing a True/False(Y/N) if text in a comma separated string is in a separate column

DMJerry

Hello,

 

I have data that looks like this and the goal is to validate if the order season is in the selling season.  I tried like but it didn't seem to be consistent.   Any help would be appreciated.

Order Season	Selling Seasons	Goal
18SP	18SP,18SU,18FA,19SP	Y
19FA	18SP,18SU,18FA,19SP	N
18FA	18SP,18SU,18FA,19SP	Y
20SP	18SP,18SU,18FA,19SP	N

 

Thank you,

 

DMJerry

GrantSmith

Do you have an example of your like statement or how it wasn't consistent?

 

Like should work to determine if the order season is in your selling season CSV string.

 

CASE
  WHEN `Selling Seasons` like CONCAT('%', `Order Season`, '%') THEN 
    'Y' 
  ELSE 
    'N'
END

GrantSmith

Do you have an example of your like statement or how it wasn't consistent?

 

Like should work to determine if the order season is in your selling season CSV string.

 

CASE
  WHEN `Selling Seasons` like CONCAT('%', `Order Season`, '%') THEN 
    'Y' 
  ELSE 
    'N'
END

Unknown

Thank you!  The concat was the key that I missed.  Appreciate it sir!