If you have two features with the same project number but different startdates, how do you know which one is correct? Likewise, if you have 10 features with the same project number and three different startdates, which one is correct?
Normaly that won't be the case, but if it happens, i can look it up in a table. I also could join everything with that table, but because there is also al lot of old/historic date i don't have information for all the project numbers.
Hi,
1. Create an attribute ATTR1 by concatenating attributes like startdate-owner for all features
2. Take a parallel line and use duplicate filter based on projecnumber and consider unique + Create an attribute ATTR2 with startdate-owner for all features
3. Pass unique records thru supplier in feature merger (Records from Point 2)
4. Pass all the records thru Requester in feature merger (Records from Point 1)
5. Place a tester for records from MERGED port and compare ATTR1=ATTR2
6. Features from Passed port are FINE and features from Failed having problem
Pratap