topic Can LOAD statement ends with AUTOGENERATES function in QlikView

Can LOAD statement ends with AUTOGENERATES function

Mon, 13 Dec 2010 10:26:26 GMT

DateIsland:
LOAD
date($(vMinDate) + rowno() - 1) AS D,
year($(vMinDate) + rowno() - 1) AS Y,
month($(vMinDate) + rowno() - 1) AS M,
date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY') AS MY
AUTOGENERATE
vMaxDate - vMinDate + 1;

Can LOAD statement ends with AUTOGENERATES function

spsrk_84 — Mon, 13 Dec 2010 10:57:09 GMT

Hi,

YEs the load statement can end with autogenerate statements..

ex:

Load RecNo( ) as A, rand( ) as B autogenerate(10000);

One thing i didnot understand what was the actual problem in script.

Regards

Ajay

Can LOAD statement ends with AUTOGENERATES function

Mon, 13 Dec 2010 11:06:00 GMT

Sintex error while compiling script.

Missing FROM

Can LOAD statement ends with AUTOGENERATES function

Mon, 13 Dec 2010 11:07:18 GMT

is something wrong in script????

Can LOAD statement ends with AUTOGENERATES function

spsrk_84 — Mon, 13 Dec 2010 11:40:48 GMT

Let vMinDate='01/01/2010';
LET vMaxDate=Date(Today(),'DD/MM/YYYY');

DateIsland:
LOAD
date($(vMinDate) + rowno() - 1) AS D,
year($(vMinDate) + rowno() - 1) AS Y,
month($(vMinDate) + rowno() - 1) AS M,
date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY') AS MY
AUTOGENERATE
vMaxDate - vMinDate + 1;

I tried in the above way it is executing properly..i think you are getting the error may be you didnot declare the variables vMinDate and vMax Date.

check it once..

Regards,

Ajay

Can LOAD statement ends with AUTOGENERATES function

Mon, 13 Dec 2010 11:45:33 GMT

Temp:
load
num(min(Date)) as MinDate,
num(max(Date)) as MaxDate
Resident

Data;

LET vMinDate = peek('MinDate',0,'Temp');
LET vMaxDate = peek('MaxDate',0,'Temp');

Drop table Temp;

DateIsland:
Load
date($(vMinDate) + rowno() -1) as D,
year($(vMinDate)) + rowno() -1) as Y,
month($(vMinDate)) + rowno() -1) as M,
date(monthstart($(vMinDate)) + rowno() -1),'MMM-YYYY') as MY
AUTOGENERATE (vMaxDate - vMindate + 1);

This is my code ...

can u pls check whats wrong in bove script

SV:Re: Can LOAD statement ends with AUTOGENERATES function

gandalfgray — Mon, 13 Dec 2010 11:54:23 GMT

in the LET statement you use uppercase D vMinDate

in the autogenerate you refer to vMindate (lowercase d)

SV:Re: Can LOAD statement ends with AUTOGENERATES function

Mon, 13 Dec 2010 12:54:57 GMT

thanks buddy