topic load in script in App Development

load in script

maxronny — Fri, 15 Nov 2024 22:44:15 GMT

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.

Re: load in script

rwunderlich — Thu, 14 Jul 2022 17:21:55 GMT

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

Re: load in script

Or — Thu, 14 Jul 2022 17:22:12 GMT

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.