ezmac13

I believe I figured it out… case when Date >= '08/01/2023' and Team Member in ('Name') then (case when Team in ('Team A') then 'Team B' else Team end) else Team end

in How do I reflect team member on Team A before date and Team B after date. Comment by ezmac13 September 2023

Thanks Mark. I do want all data from the left table and to only provide exact matching data from the right table so the left join is correct in my situation. I will create a copy and test.

in ETL join is matching multiple values - not exact matches Comment by ezmac13 November 2021

I was able to find a solution that correctly identifies the week date range starting Monday and ending Sunday. If there are any other suggestions/solutions please let me know. CONCAT(DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-1),'%b %d'),' - ',DATE_FORMAT(SUBDATE(`DATE`, WEEKDAY(DATE_ADD(`DATE`,-1))-7),'%b…

in Converting Week Numbers to Dates for custom week date range (Monday - Sunday) Comment by ezmac13 August 2020

ezmac13 Member

Comments