-
Forward Filling using ETL/ Without Python tile
Hello, I am trying to work out a logic to forward fill values. Below is an example of what I want to achieve: I want to forward fill the Calculation column values and the grouping will be based on platform and code. So, I want to populate last non null value instead of zero in the calculation column. So, the output then…
-
Median Date
Hello, I have 2 columns- One has different markets like A, B and C. Each market has some dates. The scenario is if I pick A- there is a range of dates with a minimum date, maximum date. I want to create a new date column which will populate median of the above date range for A in it. Obviously, the median will be one date…
-
Remove lookback period from the data and see the values.
I have a dataset which holds transaction data. I have dates, i have derived a week column from date which has values like “2024/17”, etc. and I usually filter data based on weeks. My use case is when I select a week using 2 variables- one will pick year and other will pick week number, I want to subtract lets say past 4…
