Putting Current day and Previous day as columns instead of rows

DANIH · 2021-08-06T17:29:24+00:00

There was an error rendering this rich post.

Hello!

I have run into a problem just like this link:

https://dojo.domo.com/discussion/14086/current-day-vs-previous-day-in-table

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!

Find more posts tagged with

Accepted answers

MarkSnodgrass

@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.