Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
flyingcheesehea
Contributor II

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
erich_shiino
Honored Contributor

Static text into a field during LOAD

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

2 Replies
erich_shiino
Honored Contributor

Static text into a field during LOAD

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

flyingcheesehea
Contributor II

Re: Static text into a field during LOAD

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.

Community Browser