[Dhis2-users] need some assistant

2012-04-24 Thread Stephen Gbanyan
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

Re: [Dhis2-users] need some assistant

2012-04-24 Thread Jason Pickering
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