Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Static text into a field during LOAD

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

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

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
Not applicable
Author

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.