Putting Current day and Previous day as columns instead of rows
Hello!
I have run into a problem just like this link:
I followed the sql transform but once I ran it the output dataset was the same as the input dataset. I don't know what I am doing wrong, I even uploaded a file that is exact to the example in the link above.
If someone can help me figure out why it seems like its not working for me?
Thanks!
Best Answer
-
@DANIH your final output should be SELECT * FROM transform2, not from the original input dataset. Not sure if that was just a typo, but your transform SQL looks correct that leads up to the final output.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Hi @DANIH
Can you put your MySQL code here for us to review?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
1st transform:
SELECT
`Date`
,SUM(`Sales`) As 'Sales'
,`Product`
FROM `domo_test_csv`
GROUP BY `Date`, `Product`
2nd Transform:
SELECT
a.`Date`
,a.`Sales` AS 'Current_Day'
,b.`Sales` As 'Previous_Day'
,a.`Product`
FROM `domo_test_csv` a
LEFT JOIN `domo_test_csv` b
ON a.`Date` = DATE_ADD(b.`Date`, INTERVAL 1 DAY)
AND a.`Product` = b.
Product
output data set:
SELECT * FROM `domo_test_csv`
0 -
@DANIH your final output should be SELECT * FROM transform2, not from the original input dataset. Not sure if that was just a typo, but your transform SQL looks correct that leads up to the final output.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive