Add Column Error in MySQL Transform
Hi,
I'm trying to map Google's LocationCriterionServices IDs to some Geo data from Adwords. I keep getting an error in my (case when) statement, but the SQL resources I've been checking haven't shown me what I'm doing wrong. Below is my code.
Is there another way to map 1000+ values easily in MySQL that I'm missing?
alter table `iuo_geostats_1683748494`
add COLUMN `LocationName` varchar(255) as
(
case
when geo.`CityCriteriaId` = loc.`Parent ID` then loc.`Canonical Name`
else geo.`CityCriteriaId`)
END
from `iuo_geostats_1683748494` geo
from `adwords_locationcriterionservice_08142019` loc
Comments
-
Normally the add column is a one-off process and is a separate syntax from the update clause.
From your syntax, there are two "from" and no "join" clause <- which is a clear indication of a cross join.
from `iuo_geostats_1683748494` geo
from `adwords_locationcriterionservice_08142019` locWhat I would so is a left join between the two tables and output the result to a new table instead.
select geo.*,
COALESCE( loc.`Canonical Name` , geo.`CityCriteriaId`) as LocationNamefrom `iuo_geostats_1683748494` geo
left join adwords_locationcriterionservice_08142019` loc
on geo.`CityCriteriaId` = loc.`Parent ID`
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 658 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive