topic Re: How to make my table name from AutoGenerate(1) to AutoGenerate ? in QlikView

How to make my table name from AutoGenerate(1) to AutoGenerate ?

paulyeo11 — Wed, 31 Jul 2013 11:44:21 GMT

Hi All ,

I have below script from Sok , it will generate 2 table ,

may i know how to make the QV self generate table name change from AutoGenerate(1) to just AutoGenerate ?

Let vMin = num(makedate(2012,01,01));

Let vMax = num(makedate(2013,12,31));

Load Date($(vMin)+RowNo() -1) as DATE,

Date(Floor(Monthstart(Date($(vMin)+RowNo() -1)))) as date_t

AutoGenerate

1

While Date($(vMin)+RowNo() -1) <Date($(vMax));

RATE:

LOAD date_t,

SOURCE,

EXCHANGE,

EXCHANGE_,

Currency

FROM

Account_Setup_1.xls

(biff, embedded labels, table is [RATE_$]);

Re: How to make my table name from AutoGenerate(1) to AutoGenerate ?

kaushiknsolanki — Wed, 31 Jul 2013 11:57:45 GMT

Hi,

Try this.

Temp:

Load Date($(vMin)+RowNo() -1) as DATE,

Date(Floor(Monthstart(Date($(vMin)+RowNo() -1)))) as date_t

AutoGenerate

1

While Date($(vMin)+RowNo() -1) <Date($(vMax));

Regards,

Kaushik Solanki

Re: How to make my table name from AutoGenerate(1) to AutoGenerate ?

paulyeo11 — Wed, 31 Jul 2013 12:25:03 GMT

Hi Kau

Thank you vey much.

Paul