community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

Meteoroid

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 yearCurrent quarterCurrent month
20181Q18201812

 

File 2 (Data file)

        
   (MM ICV)  (STAT ICV)     
   MOR  OP FX   MOH Rate 
 20181   113.249        113.961 20173.10% 
 20182   111.058        113.961 20183.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.

 

Meteoroid

Forgot to attached mapping file

Quasar

Hi @ishwarappa 

 

You could use 2 join tools to achieve this:

Capture.PNG

Highlighted
Meteoroid

Hi @jasperich

 

Thank you very much for the solution. This works for me.

 

Regards

Ishwarappa

Labels