SQL/Beastmode query for copying in values from another column

Katrina_Burns

Hello,

I have a dataset with lead sources from two different places, and I need to splice in the lead source from another column into the main column (Source - Mapped) only when criteria is met. I don't want to fully replace the data in the 'Source - Mapped' column because it has values that are not present in other places.

I am not the best at beastmode/SQL queries, hoping to get some help writing what I need to accomplish. Essentially, I only want to replace the value in 'Source - Mapped' if the medium = 'Further'.

Any help is appreciated!

MarkSnodgrass

You are close. It should look like this:

CASE WHEN LeadsData.Medium = 'Further' THEN myothercolumn ELSE LeadsData.Source-Mapped END

You'll need to replace myothercolumn with your actual column that you want to use.

Katrina_Burns

Thanks so much! I knew I was close to where I wanted to go but wasn't sure how to get there. Much appreciated.