Autogenerate

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

what is "Autogenerate" and how it will work "Autogenerate 0" in script level?

Re: Autogenerate

sunny_talwar — Sat, 30 Apr 2016 19:11:02 GMT

Autogenerate is used to create a table which is not coming from any database. For example if I want to create a Dummy Data table I can use it like this:

Table:

LOAD *,

WeekStart(Date) as WeekStart;

LOAD Date(MakeDate(2009, 12, 31) + RecNo()) as Date,

Ceil(Rand() * 100) * 10 as Sales

AutoGenerate (Today() - MakeDate(2015, 12, 31));

Here is is creating a table with date from Dec 31st 2015 till today (121 rows of data) and creating a sales field using Rand() function.

AutoGenerate 0 is used to create table with 0 rows. This is useful when you are using for loop

Table:

LOAD 0 as Dummy

AutoGenerate 0;

FOR i = 1 to 10

Concatenate(Table)

LOAD....

FROM ....

NEXT

DROP Field Dummy;

So that I can concatenate, I can create a table with no data in it.

Re: Autogenerate

clondono — Sat, 30 Apr 2016 19:13:16 GMT

Hi Mahesh,

You can find "Autogenerate" explained and with samples here:

Autogenerate Your Data

topic Autogenerate in QlikView

Autogenerate

Re: Autogenerate

Re: Autogenerate