Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
;
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
;
Thank you, Gregor!!! It's amazing how something so simple was so hard to find. Go figure. Thanks again!