I want to put one particular word into a field (every record) during a LOAD statement. How do I do this?
The load would look like this:
'TEST' AS PARTICULAR_WORD
FROM / RESIDENT ...
You just need to include it inside quotes and name it as a field.
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.
Retrieving data ...