Exchange rate static how to make it dynamic by month

[paulyeo11]

Hi All

Below script work fine , but now my user need exchange rate by month . and not base on standard exchange rate for 2013.

LOAD * INLINE [

What If Dimension Rate, Column89, Column899

          S$,Rate,SGD $ Currency

          Org,Rate_,Foreign Currency

          ];

LOAD * INLINE [

SOURCE_GL,Currency, Rate

TDSS,SGD, 1

ADL,SGD, 1

TDSPG,RM, 2.4

TDSID,ID,8000

TDSKL,RM, 2.4

TDST,THAI, 25

];

LOAD * INLINE [

SOURCE_GL,Currency, Rate_

TDSS,SGD, 1

ADL,SGD, 1

TDSPG,RM, 1

TDSID,ID, 1

TDSKL,RM, 1

TDST,THAI, 1

];

so i create below :-

date_t	SOURCE	EXCHANGE	EXCHANGE_
1 January 2011	TDSPG	2.1	1
1 February 2011	TDSPG	2.2	1
1 March 2010	TDSPG	2.3	1
1 April 2011	TDSPG	2.4	1
1 May 2011	TDSPG	2.5	1
6 June 2011	TDSPG	2.6	1
1 July 2011	TDSPG	2.7	1
1 August 2011	TDSPG	2.8	1
1 September 2011	TDSPG	2.9	1
1 October 2011	TDSPG	3	1
1 November 2011	TDSPG	3.1	1
1 December 2011	TDSPG	3.2	1

My question is , how to modify the part 1 script , so that it will have exchange rate by month.

Paul