Forum Discussion
Selecting active records from a table
I have a table of data that contains one or more records for a particular item. Only one record is the current active record and this has to be determined based on the values in several date fields...
Hi RobDueck ,
I create some dummy data for demo: Exercise File
You can open the editor and follow the steps there, and you can also modify some filter steps to better fit in your case. Thanks!
StartPoint:
EndPoint: