Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ishwarappa
7 - Meteor

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.

 

3 REPLIES 3
ishwarappa
7 - Meteor

Forgot to attached mapping file

jasperlch
12 - Quasar

Hi @ishwarappa 

 

You could use 2 join tools to achieve this:

Capture.PNG

ishwarappa
7 - Meteor

Hi @jasperich

 

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

 

Regards

Ishwarappa

Labels