Static text into a field during LOAD

[Anonymous]

I want to put one particular word into a field (every record) during a LOAD statement. How do I do this?

[erichshiino · Accepted solution]

Hi,

The load would look like this:

LOAD

FIELD1,

FIELD2,

'TEST' AS PARTICULAR_WORD

FROM / RESIDENT ...

You just need to include it inside quotes and name it as a field.

Regards,

Erich

[Anonymous]

Perfect, thanks... That's almost exactly how I was trying to do it, but I was using double quotes. I've really got to get used to QlikView's preference for single quotes!

When in double quotes, the text is treated as a field name.