Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everybody,
i have a problem with the following script:
ODBC CONNECT32 TO [HR-Assenze] (XUserId is KHGKaZFMbD, XPassword is FSGTOKVMBLbGVQJGQBMQTGD);
SQL SELECT *
FROM "EW_BELTRAMI".dbo."Assenze_View";
LOAD
MonthStart(inizio, 0) AS MESEINIZIO,
MonthEnd (fine, 0) AS MESEFINE,
Today AS Oggi;
i have no problem until the LOAD command. i don't where i err, but i don't get the "MESEINIZIO" "MESEFINE" and "OGGI" as new fields.
please help.
thank you.
The LOAD should be on top of the SQL, like this:
LOAD
MonthStart(inizio, 0) AS MESEINIZIO,
MonthEnd (fine, 0) AS MESEFINE,
Today(1) AS Oggi;
SQL SELECT *
FROM "EW_BELTRAMI".dbo."Assenze_View";
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Looks like you're got things in the wrong order. Unless specified otherwise, a Load will read from the query directly *below* it, not the one above. You would also probably want to:
Load *, MonthStart(inizio, 0) AS MESEINIZIO,
MonthEnd (fine, 0) AS MESEFINE,
Today AS Oggi;
As you will otherwise get only these three fields with none of the original ones.
The LOAD should be on top of the SQL, like this:
LOAD
MonthStart(inizio, 0) AS MESEINIZIO,
MonthEnd (fine, 0) AS MESEFINE,
Today(1) AS Oggi;
SQL SELECT *
FROM "EW_BELTRAMI".dbo."Assenze_View";
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Looks like you're got things in the wrong order. Unless specified otherwise, a Load will read from the query directly *below* it, not the one above. You would also probably want to:
Load *, MonthStart(inizio, 0) AS MESEINIZIO,
MonthEnd (fine, 0) AS MESEFINE,
Today AS Oggi;
As you will otherwise get only these three fields with none of the original ones.