Comments
-
I ended up doing the same thing. Sounds like WITH probably just isn't available in Domo then. Thanks for your input
-
Guess I'll try Domo Support then. Thanks for the input
-
The cancel link usually isn't there. I think it might only show up for magic ETL dataflows? Whereas most of the ones I use are MySQL dataflows.
-
Thanks, that's all really good info to know. I'll try calling the API directly and see if it turns out the same.
-
Yes, that did exactly what I needed, thanks. Apparently I didn't search through the date functions documentation thoroughly enough. For any future searchers, this is the exact line of code I used: STR_TO_DATE('1/31/2015', '%m/%d/%Y')
-
@kshah008not exactly, there is some additional transformation and formatting that require the use of a SQL dataflow, rather than a magic ETL. And in any case, I've found a way to get Domo to recognize "1/1/2015" as a date, but I'm wondering if there's an easier way to do it. It seems counterintuitive to me that if Domo…
-
Shucks. Well, good to know, thanks.