Fetch the value in one file based on key in another file.

ishwarappa

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.

Data Input.xlsx

jasperlch

Hi @ishwarappa 

You could use 2 join tools to achieve this:

New Workflow1.yxmd