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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive