mysql transform unknown column
I'm trying to do what seems like a pretty basic transform on a salesforce dataset in Domo and it's throwing an error. Might very well be due to my lack of SQL expertise
The database reported a syntax error. Unknown column 'ConvertedOpportunity.Name' in 'field list'
The field is in the list, ConvertedOpportunity.Name is in the input dataset as shown in the "show columns" widget, but maybe because of the "." it doesn't like it. There might be other things wrong with this query as well, but any help would be appreciated.
SELECT
date(Marketing_Inquiry_Date__c) as date,
COUNT(IF(Marketing_Inquiry_Date__c=null,null,1)) as inquiries,
COUNT(IF(Date_Identified_as_MQL__c=null,null,1)) as mqls,
COUNT(IF(ConvertedOpportunity.Name=null,null,1)) as opportunities
from leads_with_opportunities
group by date
Best Answer
-
try using the back tick `
`ConvertedOpportunity.Name`
0
Answers
-
try using the back tick `
`ConvertedOpportunity.Name`
0 -
That did the trick, thanks!
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
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 83 App Studio
- 46 Variables
- 777 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive