Nested UPDATE statement not populating column
I am trying to update a dataflow with MySQL. I have a report being pulled into DOMO from Salesforce and I altered it as follows:
- connected Salesforce report to DOMO
- Used ETL to filter the data into five buckets. (Marketing Channels)
- Created a new column: 'Sub Channel' - value: NULL
- Output as its own ETL dataflow
I am using SQL to update the Sub Channel Column based on which marketing channel each lead belong with. From there I want to update the Sub Channel column based on the campaign.
My code is as follows:
I had it working previously, but now I can't remember why it is not working anymore. I tried setting the Sub Channel column to empty string and NULL, but neither populate the column with values.