Discussion Board for collaboration on QlikView Scripting.
Full disclosure I'm not a QV developer, just playing one on TV.
Trying to load several fields from and Oracle DB and in the process create a new Month and Year field based upon a timestamp field that is coming in.
MONTH (CREATE_DATE) as CREATEMONTH;
ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: "MONTH": invalid identifier
Can I do this or am I just doing somethign stupid?
Thanks in advance,
Go to Solution.
In principle you should be able to do this, but it is better if you use a preceding load:
SQL SELECT * FROM ...
This worked perfectly. Thanks for the quick reply.
You can use To_Char function too
To_Char(Date_Field,'MM') = 01
To_Char(Date_Field,'MON') = JAN
To_Char(Date_Field,'YY') = 03
To_Char(Date_Field,'YYYY') = 2003
Also you can go with preceding load as suggested by Henric Cronström.
Sorry, Gysbert, accidentally deleted your post but it did work as well. All great options.