I am trying to solve for the following variations in my data set. I need to filter rows to only keep the most recent effective date.
data sample and desired results are attached.
Any Ideas would be greatly appreciated.
Solved! Go to Solution.
use summarize tool and group by column and Max date
no need to use select and filter tool
since your sample data has nulls and unwanted columns so i used select and filter tools
Thank you all!!!