Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to set a value in a field


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?

1 Solution

Accepted Solutions
sinanozdemir
Not applicable

Re: How to set a value in a field

Hi,

Try like this:

LOAD

     'Yes' As SWEEP_STAT

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

4 Replies
sinanozdemir
Not applicable

Re: How to set a value in a field

Hi,

Try like this:

LOAD

     'Yes' As SWEEP_STAT

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

Not applicable

Re: How to set a value in a field

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

Not applicable

Re: How to set a value in a field

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

sinanozdemir
Not applicable

Re: How to set a value in a field

You are welcome.