compare old table with new table

[GIS_DEVLOPER]

Hi,
I have two village tables (new ,Old) and each table have three columns region ,city and village ,I would like to compare the new with old
to see if there is new village and to see if village changed from city to another city or changed from region to another region
I attached the excel file



Regards,

[Richard Buttrey]

See attached for one method which uses a couple of helper columns.

Incidentally when uploading a sample please use real data, even if anonymised, that accurately represents the format of the actual data. i.e. typical string lengths, position of character spaces and other stuff which may be relevant to any analysis.

All to often we find ourselves offering solutions to a trivial example which then doesn't work with the production data.

[GIS_DEVLOPER]

Thanks Richard, The real data is very big 25000 records and it is not in English because of that I uploaded sample data.
how I can specify the type of change for example " change city" or "change region" or "change region & city" ??


Regards,

[GIS_DEVLOPER]

Thanks Richard, The real data is very big 25000 records and it is not in English because of that I uploaded sample data.
how I can specify the type of change for example " change city" or "change region" or "change region & city" ??


Regards,

[oeldere]

1) is this data

k r g

always related to

k h g


2) are there duplicated values in the old or new range.

[GIS_DEVLOPER]

1) k r g is related to k h g , that mean the village (k) is changed from city (h) to city (r)
2) yes , there is duplicated data (a b c) is same in booth table

[Richard Buttrey]

Thanks Richard, The real data is very big 25000 records and it is not in English because of that I uploaded sample data.
how I can specify the type of change for example " change city" or "change region" or "change region & city" ??


Regards,

Hi,

The general principle is to decide exactly what you want to compare. Is it just a single field, e.g. village, or two or more fields.
When you know what you want to compare create a helper column for each table that concatenates the fileds you want to compare into a single field.

Then use an

Please Login or Register  to view this content.

If this returns an error you know there is a difference.

Wrap this formula in an

Please Login or Register  to view this content.

to show where there has been a change. Follow the example I gave you earlier.