With the Where clause, Am i not limiting my table with the Match(Status, 'A','P') and Processed = 'F' filter?
But my goal is to keep all the data and make a new filed Active date.
Something like that
IF(Match([Status],'A','P') and [Processed]='F' and [Update Date]=Min([Update Date]), [Update Date], ' ') as [Active Date]
I know this piece of code is wrong but the idea is like that.
You can add to your table a min update date, using a group by and left join (bold)
left join (yourtable)
min(updatedate) as minupdatedate
group by product; // I think you want the min date by product
then you can do a resident table with an if condition on status, processed, updatedate, minupdatedate to calculate the activedate field