I have snapshot data everyday that has customers and their statuses. I want to create a formula that looks back one day and reports the status (previous day status) How would I do that in Magic ETL?
You can use a Rank and Window tile with LAG to get the prior value based on your sorting.
