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

[paulyeo11]

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_$]);

[kaushiknsolanki · Accepted solution]

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

[paulyeo11]

Hi Kau

Thank you vey much.

Paul