Hello, I hope someone can help.
I have two data set, Historical Raw and Current Raw.
Historical Raw contains all of last month up to yesterday's (current month) projected and actual data while, Current Raw contains actual and projected numbers of the last few days of the previous month and the entirety of the current month including future dates.
I would like to ask some help if there is a dynamic way to remove the current month's data from the Historical Raw and vice versa on the Current Raw?
I have attached a sample of the raw files.
Thank so much!
@V794821 you can setup a filter tool and only filter the current month and year from the current input file and filter out those from the historical file