topic Re: Looping Script using Date & Hour as Parameter in QlikView

Looping Script using Date & Hour as Parameter

Mon, 13 Feb 2017 11:33:36 GMT

Hello,

I have to create a loop script which has as parameter for the next load the last date & hour (YYYY-MM-DD hh:mm:ss) of the field 'date'.

This parameter I've already have using "LET vInitialDate=Peek('date',-1)" in the end of the script. But how can I stop the looping, considering Now() as the final date? I'm stuck with this.

Tks!

Re: Looping Script using Date & Hour as Parameter

rahulpawarb — Mon, 13 Feb 2017 11:40:22 GMT

Hello Marcelo,

Could you please share the application with sample data? This will help us to identify the issue and provide fix for the same.

Regards!

Rahul

Re: Looping Script using Date & Hour as Parameter

Mon, 13 Feb 2017 11:45:20 GMT

Hello Rahul,

I can't share the application, but the script has the following model:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=URL&$(vInitialDate)|$(vFinalDate)";

RestConnectorMasterTable:

SQL SELECT

"success",

"__KEY_root",

(SELECT

"id",

"date",

"__FK_data"

FROM "data" FK "__FK_data")

FROM JSON (wrap on) "root" PK "__KEY_root";

Table:

LOAD

[id],

[date],

[__FK_data] AS [__KEY_root]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_data]);

Remembering that the variable vFinalDate is Date(Now(),'YYYY-MM-DD hh:mm:ss'). And the vInitialDate is always the last record from the field "date" (YYYY-MM-DD hh:mm:ss).

Tks

Re: Looping Script using Date & Hour as Parameter

Mon, 13 Feb 2017 17:38:28 GMT

Nobody else?