2 Replies Latest reply: May 19, 2011 3:01 PM by Ernesto Laboy RSS

    LOAD constant value field for all records read

    Ernesto Laboy

      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.