Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone explain the autogenerate with good examples....i know meaning of this..but i need to know the output of this..how the output will come..
I assume this
Explanation foe below:
Rowno() Means will generate the values from 1 - ∞. So here, When ever you want to cut in between 1-∞ then you should use AutoGenerate function. From my below expression it generates 10 values from starting 1.
LOAD RowNo() as ID AutoGenerate 10;
I recommend you to create one qlikview work file(qvw) and then use this from script and select ID as field from UI then see how this works and try to change AutoGenerate value and see how this moving.
Hope helpful
Hi Sindhu,
Autogenerate is used if data should be automatically generated by QlikView. (Please check QlikView Help)
For more,
Kind regards,
Ishfaque Ahmed
thanks..
From Qlik Help
Load
RecNo( ) as A,
rand( ) as B
autogenerate(10000);
Note:- This load generate 10000 rows table with row fields this is based on the requirement.
Or you can search many post related to this on the community.
Regards
Anand
Hi ahamed...
now i got idea about autogenerate thanks..
thank u so much
Hi Sindhu,
We can do two types of AutoGenerate function.
Below is the content for your reference.
Header 1 |
---|
AG: LOAD (RowNo() + 1) as Row_No AutoGenerate(25); AG1: LOAD (RowNo() + 1)-1 as Row_No1 AutoGenerate(25); |
Refer the attachment.
Hi Sindhu,
A most used example scenario of autogenerate :
Making dates :
vToday =Floor( Today());
vlast7thDay = $(vToday)-6;
LOAD $(vlast7thDay) + IterNo() -1 as Date
AutoGenerate 1 // this wil generate 1 row of Date Field each time the while loop repeats.
While $(vlast7thDay) + IterNo() -1 <= $(vToday);