Over Partition Clause in Magic ETL, or SQL transform
I'm looking for a solution to create a new column that will either copy a shipping timestamp on all rows, if the shipping date exist on one of the rows. If the shipping date doesn't appear on a row, then it can be null. Or maybe more preferable, a true/false statement, if a shipping timestamp is associated to an account,…
