MySQL - Creating new column via LEFT JOIN
Hello!
I am having trouble creating a new column (Dummy) to identify rows that I need to remove from my output in MYSQL dataflow (Beginner at using Domo). The query is valid, but when the output is produced, the column "Dummy" does not appear in the dataset. See below.
SELECT
A.`Posting Title`,
A.`Weekly Reporting Date`,
A.`Weekly Report Stage`,
A.`Funnel Stage`,
A.`Candidate Link`,
A.`Origin`,
A.`Department`,
A.`Days in Stage`,
A.`Days to Hire`,
A.`Days to Archive`,
A.`Offer Acceptance Date`,
A.`Candidate Journey Start Date`,
A.`Event Date`,
A.`Previous Event Date`,
A.`Previous Opportunity Stage`,
A.`Candidate Name`,
A.`Hiring Manager`,
A.`Posting Created Date`,
A.`Owner`,
A.`Posting Country`,
A.`Posting Location`,
A.`Team`,
A.`Posting Status`,
A.`Archive Reason`,
A.`Candidate Email`,
Bad.`Dummy`
FROM `lever_weekly_khtest` AS A
LEFT JOIN (SELECT `Candidate Name`,
"Remove" AS Dummy
FROM `lever_inactive_report`
WHERE `Candidate Name` IS NOT NULL) AS Bad
ON A.`Candidate Name` = Bad.`Candidate Name`
WHERE Bad.`Dummy` IS NULL;
Thank you! :)
Best Answer
-
UPDATE: I am in fact a
Dummy
because I was selecting the wrong transformed dataset in my output. All is well, and the column is now appearing!1
Answers
-
Hi @keeeirs10
Is this query being done in your output section or as a transform?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
UPDATE: I am in fact a
Dummy
because I was selecting the wrong transformed dataset in my output. All is well, and the column is now appearing!1 -
Thanks for the input Grant! See above for the solution lol.
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 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