Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please Explain Autogenerate With Example.
Thanks in Advance.
Thanks and Regards,
Gayathri Devi
Hi Gayathri,
is used in a LOAD statement if data should be automatically generated by QlikView
some of the most common use is
- calendar generation (manojqlik)
- test data generation with rand (arul settu)
- log/trace of the script (see above)
all together
Rand: load rand()*100 as field1 autogenerate 10;
Log: load 'INFO' as Type, 'After rand' as Info, now() as Time autogenerate(1);
let varMinDate = floor(Today());
let varMaxDate = num(makedate(2014,12,31));
sleep(1000);
Cal:
load
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
load 'INFO' as Type, 'After calendar' as Info, now() as Time autogenerate(1);
Regards,
Seenu
Thank you so much.
Thank you so much