I have a data extension that is built by a SQL query. The automation runs daily to add/update data.
Its appointment data so what im trying to understand is what defines if a field is updated or not? My query runs fine however once data is populated if the time changes it doesn't get updated.
It uses a match key of subscriber key and appointment key as they could have more than one appointment
Any help would be appreciated