RGranada Contributor 
-
Re: Updating a column or deleting rows of a table in SQL transform (saving to the source table)
Hi, I think that you are trying to accomplish an upsert. Update historical data with Delta data and add new rows if they exist, assuming that the historical table and delta table schemas are identica…1 -
Re: I'm trying to calculate number of days without weekends, can someone please help?
Hi, Try this beastmode : CASE WHEN YEARWEEK(`EDate`) = YEARWEEK(`SDate`) THEN ((DATEDIFF(DATE(`EDate`),DATE(`SDate`)) - (CASE WHEN DAYOFWEEK(`SDate`) = 1 THEN 1 ELSE 0 END) - (CASE WHEN DAYOFWEEK(`ED…1 -
Re: Distance and MPG
Hi. I don't know if window functions can be used in Magic ETL. And i can't see any way for a bestmode to get previous record values... But we never know!1 -
Re: Distance and MPG
Hi, I would make a transformation in a redshift dataflow in order to get the odometer value in the last reffil. Like this : Select *,NVL(LAG("odometer mileage") RESPECT NULLS OVER (PARTITIO…1 -
Re: Heatmap Table Colors Not Working
I Think i know what is going on. Domo is using the year number to calculate the intervals of your heat map. One way to avoid this is no to allow Domo to do this by making impossible for Domo to conve…1
