How to set a value in a field

[#1]

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?

[sinanozdemir · Accepted solution]

Hi,

Try like this:

LOAD

     'Yes' As SWEEP_STAT

And ignore the original field in the load script, just use the above field.

[#3]

That didn't seem to work, is there another way to do it?

[#4]

apologies it did work, I have another table that is causing skewed results.

[sinanozdemir]

You are welcome.