locked
Matching Records using View RRS feed

  • Question

  • I have create a view that combines two tables from different sources for parcel data, some of the records are available in the first table [A] but not available in [B], and some of them are available in [B] but not available in [A]. I used a view with Left Outer join to keep all the records and compare between them to find the mismatches, this is shown below:

    A:

    Parcel_ID_A

    1

    2

    3

    4

     B:

    Parcel_ID_B

    2

    4

    6

    8

    The result of the view are

    Parcel_ID_A

    Parcel_ID_B

    1

    Null

    2

    2

    3

    Null

    4

    4

    I want to add a column [Matching] to this view that writes “Matched” when the records are matched between the two tables, and writes “Unmatched” when the records are not matched as below:

    Parcel_ID_A

    Parcel_ID_B

    Matching

    1

    Null

    Unmatched

    2

    2

    Matched

    3

    Null

    Unmatched

    4

    4

    Matched

    Is this possible?

    Any help is highly appreciated,

    Best,

    Hani


    Hani Draidi GIS Engineer


    • Edited by Hani Draidi Sunday, January 24, 2016 8:51 AM
    Sunday, January 24, 2016 8:23 AM

Answers

All replies