Hi All,
I have a situation and need some help. The are two facilities in my
database with the same name but the difference is capital letter. One
is spell Juarzon Clinic and the other is Juarzon clinic. Both of them
have the same data in for September and October 2011. In November 2011
Juarzon
By duplicated, you mean something like
Juarzon Clinic has a data element = 1
Juarzon clinic has a data element = 1
and the merged facility has a new value = 2?
In principle, you should be able to run an SQL command like
UPDATE datavalue set sourceid = new organisationunitid where
sourceid = old
2 matches
Mail list logo