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