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`
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
try using the back tick `
`ConvertedOpportunity.Name`
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
That did the trick, thanks!
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 508 Automate
- 114 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive