Hi
I have two data files (1) Key file (2) Data file. I need to fetch the value in second file based on the key in first file.
File 1 (Key file)
Current year | Current quarter | Current month |
2018 | 1Q18 | 201812 |
File 2 (Data file)
(MM ICV) | (STAT ICV) | ||||||
MOR | OP FX | MOH Rate | |||||
20181 | 113.249 | 113.961 | 2017 | 3.10% | |||
20182 | 111.058 | 113.961 | 2018 | 3.70% | |||
20183 | 106.444 | 113.961 | |||||
20184 | 105.300 | 113.961 | |||||
20185 | 107.248 | 113.961 | |||||
20186 | 109.523 | 113.961 | |||||
20187 | 110.188 | 113.961 | |||||
20188 | 112.973 | 113.961 | |||||
20189 | 110.827 | 113.961 | |||||
201810 | 111.995 | 113.961 | |||||
201811 | 112.399 | 113.961 | |||||
201812 | 112.753 | 113.961 |
Requirement 1: Get the MOR and OP FX rates as per the current month in (1)
Requirement 2: Get the MOH Rate based on the current year(2)
Attached both the input files for reference.
Solved! Go to Solution.
Hi @jasperich
Thank you very much for the solution. This works for me.
Regards
Ishwarappa