Forum Discussion
Solved
Summarize Data by Max Date
Hello! I have a status transactions table as follows: date id status 1/1/2019 A New 1/15/2019 A Open 2/1/2019 A Closed 2/15/2019 B New 3/1/2019 B Open 3/15/20...
Thank you Ashish_Mathur.
This does solve the problem. However, is it possible to do this without duplicating the input data table for every relevant date? The mock data was only 5 or so records, but your method increased that record count to over 300. Considering my real data consists of thousands of records over many years, this method would not be sustainable in the long run. What do you think?
Hi,
It could be unsustainable. Only you can try and offer feedback. This is the only method i know.