I have a query running as an update to capture the data from source data extension and put it on target Data extension as update the matching records and insert new if not matching.
Yesterday we have added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.
Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.
Records are coming from source data extension to target but all records are having the newly created field as a blank.
Why do I observe this behavior? How do I fix it?