Putting Current day and Previous day as columns instead of rows


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?


Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    edited August 6 Accepted 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.


  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @DANIH

    Can you put your MySQL code here for us to review?

    DANIH ⚪️
    edited August 6


    1st transform:



    ,SUM(`Sales`) As 'Sales'  


    FROM `domo_test_csv`

    GROUP BY `Date`, `Product`

    2nd Transform:



    ,a.`Sales` AS 'Current_Day'

    ,b.`Sales` As 'Previous_Day'


    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`