MySQL newbie question
I have a dataflow I've built in Magic ETL, and I want to add a new column using a conditional statement to return the value from one of 3 existing columns (doing this in Beast Mode prevents me from getting the correct aggregations, so I'm trying to add in the dataflow itself).
So I want to have Invoice Sales returned if >0, if not then return j_quote_ if >0, if not then return WP Price. The Magic ETL dataflow basically looks like this, and I want to add the column in bold:
Job No_1 | J_JOB_STATUS | Invoice Sales | WP Price | J_QUOTE_ | Total Job |
123456 | JOB INVOICED. INVOICE# 12345678 | 2992.5 | 3021.02 | 0 | 2992.5 |
123457 | JOB ENTERED | 340 | 0 | 340 | |
123458 | JOB CARD PRINTED | 6196 | 6240 | 6240 |
This is the syntax I have in MySql, but I'm a newbie at SQL, and I'm sure I'm missing something simple. Any suggestions are welcome:
Thanks!
Best Answer
-
Here you go, this should do the trick.
SELECT *,
CASE WHEN `Invoice Sales` > 0 THEN `Invoice Sales`
WHEN `Invoice Sales` < 0 AND `J_QUOTE_` > 0 THEN `J_QUOTE_`
ELSE `WP Price`
END AS 'Total Job'
FROM sales_wp_quote_summarized_by_job
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
Excellent. Thanks.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有