load in script

[maxronny]

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.

[rwunderlich · Accepted solution]

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

[Or · Accepted solution]

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.