topic Rough Join in Mapping Questions https://community.esri.com/t5/mapping-questions/rough-join/m-p/749605#M8079 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />Is there any possible way to do a "rough" join between a featureclass and a table?</P><P>Similar to a lookup table in excel, I need to be able to have model builder approximate a unit rate if part of a feature code (ie. Water-Pressure Main-PVC-125 does not exist by <SPAN>Water-Pressure Main-PVC-150:$400 does</SPAN>) does not have a unit rate associated with the code. Ideally I would have unit rates for every code, but need a way to catch ones that I do not have.</P><P>Thanks!</P></BODY></HTML> Thu, 16 Mar 2017 21:16:56 GMT DougMerrick 2017-03-16T21:16:56Z Rough Join https://community.esri.com/t5/mapping-questions/rough-join/m-p/749605#M8079 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />Is there any possible way to do a "rough" join between a featureclass and a table?</P><P>Similar to a lookup table in excel, I need to be able to have model builder approximate a unit rate if part of a feature code (ie. Water-Pressure Main-PVC-125 does not exist by <SPAN>Water-Pressure Main-PVC-150:$400 does</SPAN>) does not have a unit rate associated with the code. Ideally I would have unit rates for every code, but need a way to catch ones that I do not have.</P><P>Thanks!</P></BODY></HTML> Thu, 16 Mar 2017 21:16:56 GMT https://community.esri.com/t5/mapping-questions/rough-join/m-p/749605#M8079 DougMerrick 2017-03-16T21:16:56Z