Index Match replacement for FX rate based on

Question

I am trying to achieve a similar result to index match and fill out the FX rate on the second chart using the Date period and the Currency Code.

How would this be achieved in Alteryx? I attempted Join but would need another formula on it not sure if there is a quicker way

Currency Code202301202302202303202304202305AFA0.0115450.0111210.0111830.0113730.011555AFN0.0115450.0111210.0111830.0113730.011555ALL0.0092570.0092340.0092490.0092030.009704DZD0.0072590.0073240.0073250.0073210.0074AOK0.0000010.0000010.0000010.0000010.000001AOA0.0019640.0019770.0019610.001960.001956AOR0.0000010.0000010.0000010.0000010.000001

Currency CodeCCYFX Rate202301AFA 202302AFN 202311ALL 202302DZD 202302AOK 202306AOA 202307AOR 202308XCD 202309ARS 202310AMD 202311AWG 202312AUD

kamal03 · Answer

Hi @a4nola

Please correct me if I am wrong, Based on my understandingI have created this workflow, Let me know if this aligns with your requirements or not.

Thanks

Kamal Sharma

Index mapping.yxzp

aatalai · Answer

@a4nola couldn't you set those fields as key columns in the transpose tool?

a4nola · Answer

I cut down the output file to make it simpler but in the actual file there would many different fields along with Acct period and Currency. So transposing wont work for this use case.