-
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: I need help with my equation
In addition to the correction mentioned by @ggenovese, this segment also needs to change: date(Job Open Date)<'10/01/2024' . An unfortunate quirk of Magic ETL is that comparison operations with st…1 -
Re: Pulling the First Saturday of the previous 6 months
For a date column called "d", the filter formula would be: dayofweek(d) = 7 and dayofmonth(d) < 8 and (year(today()) * 12 + month(today())) - (year(d) * 12 + month(d)) < (case when da…1 -
Re: Regex formula works in ETL preview but doesn't show up in dataset output?
I agree with Mark, for something like this you're better off without regex. I would note, however, that you're also slightly better off just using two SPLIT_PART invocations, like this: SPLIT_PART(SP…1 -
Re: Does Magic ETL v2 Have a Max Row Limit
I've discussed and diagnosed this issue in private messages with OP, but for any others who come across this issue in the future: Federated DataSets, that is, DataSets that reside on external databas…1
