I have a Table within a database and I need to copy some values from A >> B (within the same table). Please see attached screenshot. Importantly, if data already exists at B, we should not overide any data but skip.
From A would be From the fieldid 375. Using the relid to match the line to the B side with the fieldid of 528. If the B side value is null, we should copy the value from the corresponding row. If the B side value has data, we should not copy over any data and move onto the next row.
Success story sharing