Comparing two excel tables

KamalChoudhary_in

Hi,

Im new to the Alteryx

I need to compare below two excel tables and update commments in table 1 

> We need to compare rate given in the column Rate , based on the column currency and column code of table 1  with Table 2 Columns code and currency columns EUR , SGD and HKD

So we can update commnents is Table one rate is matching or not matching with Table 2 rate 

any help woud be much appreciated 

Table1

Code	Currency	Rate	Platform	Comments
60	EUR	0.05	London	matching
61	EUR	0.05	London	No Matching
62	EUR	0.05	London
63	EUR	0.05	London
64	EUR	0.05	London
65	EUR	0.05	London
66	EUR	0.05	London
67	EUR	0.10	London
68	EUR	0.10	London
60	SGD	0.05	London
61	SGD	0.05	London
62	SGD	0.05	London
63	SGD	0.05	London
64	SGD	0.05	London
65	SGD	0.05	London
66	SGD	0.05	London
67	SGD	0.10	London
68	SGD	0.10	London
60	HKD	0.05	London
61	HKD	0.05	London
62	HKD	0.05	London
63	HKD	0.05	London
64	HKD	0.05	London
65	HKD	0.05	London
66	HKD	0.05	London
67	HKD	0.10	London
68	HKD	0.10	London

Table2

Code	EUR	SGD	HKD
60	0.05	0.01	0.00
61	0.06	0.01	0.00
62	0.05	0.01	0.00
63	0.05	0.01	0.00
64	0.05	0.01	0.01
65	0.05	0.03	0.03
66	0.05	0.05	0.05
67	0.10	0.08	0.08
68	0.10	0.10	0.10

OllieClarke

Hey @KamalChoudhary_in 

This is a simple join example (once we restructure table 2)

The records which come out the J output of the join have identical codes, currencies and rates, so they're "matching". The ones which come out the L output don't have a match, so they're "not matching"

Hope that helps - and definitely check out the learning paths https://community.alteryx.com/t5/Learning-Paths/tkb-p/learning-path to get to know Alteryx better

Ollie

MAtching.yxmd