Hi Kumar,
Thanks for the reply. Attached please find some test data.
I have included 3 different scenarios for intersection of fittings on our water lines and lateral lines:
1. Fittings that intersect only main lines
2. Fittings that intersect only lateral lines
3. Fittings that intersect both lateral and main lines
To clarify, the rule I am trying to establish within data reviewer is to identify fittings that are NOT intersecting either lateral lines OR main lines.
The composite check I have now identifies fittings not intersecting lateral lines AND main lines. For example, if a fitting is only on a main line, then it is flagging that as an error and committing a new record to the data reviewer table. I want to identify fittings that are not intersecting any of our water lines (both lateral lines and main lines), e.g. I want to identify a fitting not placed on a water line as an error.
If you want to do a screen-share session, let me know. It may be beneficial for both of us. I will be available all day (8-4:30 PM PST).
Thank you,