it there a way to reduce 12 row to 1 row ?

[paulyeo11]

Hi All

i have save the exchange rate raw data at excel file :-

As you can see the the exchange rate for indoensia is alway 8100 to 1 dollar singapore. but i need to enter 12 time . i like to ask it is possible i just enter 1 row , like 2012 instead of indicate every month ? so i can cut short my excel row.

date_t	SOURCE	EXCHANGE	EXCHANGE_	Currency
1 January 2012	TDSID	8100	1	ID
1 February 2012	TDSID	8100	1	ID
1 March 2012	TDSID	8100	1	ID
1 April 2012	TDSID	8100	1	ID
1 May 2012	TDSID	8100	1	ID
6 June 2012	TDSID	8100	1	ID
1 July 2012	TDSID	8100	1	ID
1 August 2012	TDSID	8100	1	ID
1 September 2012	TDSID	8100	1	ID
1 October 2012	TDSID	8100	1	ID
1 November 2012	TDSID	8100	1	ID
1 December 2012	TDSID	8100	1	ID

Enclosed my qv doc sample file.

[#2]

Hi,

Try below code, may be it'll solve your issue.

LOAD * Inline [SOURCE, EXCHANGE, EXCHANGE_, Currency

TDSID, 8100, 1, ID

];

LOAD

RecNo() as Rec,

MakeDate(year(Today()),RecNo()) as date

autogenerate(12);

Regards

Garry

[paulyeo11]

Hi Garry

Thank you for your code.

I decide to use excel to create a long table. Since it is one time job , i don't mind do it.

Paul