3 Replies Latest reply on Aug 8, 2018 1:49 PM by Bruce Vickers

    Problem with Left Join on Excel files

    Bruce Vickers

      I'm having trouble with joining 2 excel files.  The Left table has data for all counties in Oregon.  The right table has specific discharge information. The main purpose for the join is to have a field that I can use as a basis for a filled in map of Oregon - it looks incomplete to only show the counties with discharges.  I've done this before with the same excel sheet (All Counties) and an ODBC connection to our database.

       

      Wheeler county does not have any discharges but I want it appear in the map - (just because it doesn't have data shouldn't mean the county disappears).

       

      Please help.

       

      ~Bv