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.
- Cascading Soft Delete
- ERROR: extra data after last expected column on postgresql
- Create login and logout rows from single row
- Add parameter within SQL query - Python
- How to Count & Group SQL Results into Custom Group Categories?
- How to SQL Filter for Timestamp Differences in Toad for Oracle?
- How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
- How to find entries in a Column - where an adjacent column switches value, and then reverts back to the original value?
- SQL, How to convert VARCHAR to bigint?
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- Get mySQL MONTH() to use leading zeros?
- Select only distinct values from two tables on pgadmin without getting all combinations
- Brand name whose amount is increasing every year
- Performance loss introducing lateral join in Postgres query
- Is it possible to create a procedure with ANALYZE table instruction?
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- How can i insert/ select into a table and delete copied records from original table?
- Synapse/ ADF - How to Truncate table if dynamic config column is True in pre-copy script
- Fastest way to determine if record exists
- Unrecognized column name that I define
- SEDE Data Query to find posts that have hidden comments added by me
- What is the most efficient way to count rows in a table in SQLite?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- Preg split multi SQL by semicolon in PHP
- Mysql Pivot View
- Is it good practice to have a column for each user and a row for each user in SQL table?
- How to filter Select option to ALL