-
Re: Can I move a formula in the list of "Group by" actions?
It would definitely be an improvement to be able to reorder aggregate columns in Group By. Column order as a whole is not given the attention it deserves in Magic ETL. This workaround may be unwelcom…1 -
Re: How to fill-down nulls from earliest instance of non-null value?
The flow consists of the following: 1. Add Formula. New column name: "Row Number", Formula: ROW_NUMBER() 2. Rank & Window. Order by "Row Number". No partition columns. New col…4 -
Re: Convert to timestamp
@vaco Timestamps and Dates columns in Magic ETL don't have a format. They will always be displayed in a way that is determined by the table or card you're looking at them in, along with you…1 -
Re: Group By Issue
The flow looks like this: Inverse Amounts configuration: Join configuration: Restate Include / Exclude configuration:1 -
Re: Two Group By with SUM totals
You should be able to take the solution we did for Project Count with these changes: 1. Rename "ProjectId Const" tile to "Cost Const", name the constant "Planned Cost" i…1
