Filtering in datasets to return only most recent row with a given ID?
I have two datasets, both sourced from an XML document, which are participating in a joint data set (LEFT outerjoin). The right-side table in the outerjoin is the one that needs filtering. The dataset rows have a String ID and a Date field (among other fields), and I would like the dataset feeding into the joint dataset to…
