topic LOAD constant value field for all records read in QlikView

LOAD constant value field for all records read

Thu, 19 May 2011 18:33:54 GMT

New QV developer. I'm trying to add a field in my LOAD statement to include a fixed value, but I cannot find the syntax for such requirement. Is that even possible?

i.e.

Detail:

Load

(Here I want to add the name of the country we are extracting data from, fixed for all records)

year([Daily Prod Date]) as Year,

month([Daily Prod Date]) as Month,

week([Daily Prod Date]) as Week,

Day([Daily Prod Date]) as Day

;

SQL SELECT [Detail - Entry Date].[Daily Prod ID],

[Detail - Entry Date].[Daily Prod Date],

[Maint - Finished Products].CategoryID,

[Maint - Line Category].CategoryCode, ...................................................

Thank you.

LOAD constant value field for all records read

yasus — Thu, 19 May 2011 18:39:58 GMT

Detail:

Load

'ConstantCountryName' as Country,

year([Daily Prod Date]) as Year,

month([Daily Prod Date]) as Month,

week([Daily Prod Date]) as Week,

Day([Daily Prod Date]) as Day

;

LOAD constant value field for all records read

Thu, 19 May 2011 19:01:33 GMT

Thank you, Gregor!!! It's amazing how something so simple was so hard to find. Go figure. Thanks again!