sqletlsnowflake-cloud-data-platformmatillion
to find a the running total for a column containing two project names in matillion ETL
I want to calculate the running total separately for two project names(menlo park and SFO-BAB) in matillion etl I've already calculated the running total for both the project names combined but I need to do it separately. I've added the screenshot for reference.
Solution
I assume you want to calculate a running total for the column UnitsConsumed for every projectName:
Select
projectName,
UnitsConsumed,
SUM(UnitsConsumed) over (partition by projectName order by reportingFromDate)
FROM waterConsumption
If you only want to see Menlo Park or SFO-BAB, you have to filter your result accordingly.
- How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?
- Many to Many Self referencing relationship
- MS Access error "ODBC--call failed. Invalid character value for cast specification (#0)"
- How to instantiate user @variables?
- Multiple select queries with union, flatten to single row
- How to access my database from another server
- Round to .5 or 1.0 in SQL
- Add a grouping column to keep time entries together based on on its value, then repeat the id until the next value occurs
- Unique constraint on multiple columns in a table variable
- Is the SQL WHERE clause short-circuit evaluated?
- select to group date and time in 5-minute intervals
- Getting 'STATEMENT_ERROR' when trying to execute `SHOW PARAMETERS` in Snowflake in block
- ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query
- Insert statement asked me to insert for autoincrement column
- Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
- column is of type timestamp without time zone but expression is of type integer
- Performing a bitwise sum
- Generating random strings with T-SQL
- Is a sort passed through in a sub-select
- Creating a balance statement
- Replace calculated negative values with 0 in PostgreSQL
- SQLite constraint for making 2 columns different
- sql select with column name like
- Get mutual settlements from records using SQL
- SQL Selecting if "active" = true
- SQLAlchemy Column Types As Generic (BIT Type)
- PrestoSQL transform event data into hourly summary
- Pyspark: Select all columns except particular columns
- A mathematical way to divide overlapping time ranges into hours
- Nunjucks nested variables