Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to put one particular word into a field (every record) during a LOAD statement. How do I do this?
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
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
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.