I have a field called SWEEP_STAT in a table I am importing and I want to overwrite the existing values and make them all say 'Yes'.
I have tried a few iterations of this and can't seem to get it to work, can someone assist?
Try like this:
'Yes' As SWEEP_STAT
And ignore the original field in the load script, just use the above field.
That didn't seem to work, is there another way to do it?
apologies it did work, I have another table that is causing skewed results.
You are welcome.
Retrieving data ...