Multi field comparison

[SMjali]

Hi all,

I am new to Alteryx and I need to make a workflow that test whether a pair of fields match or not.

For example say I have two tables:

A	B	C
11221	egx	100
11082	fhd	300

and 

D	E	F
11221	egx	100
11082	fhd	300

what I want is :

A	D	Match	B	E	Match	C	F	Match
11221	11221	True	egx	egx	True	100	100	True
11082	11082	True	fhd	fhd	True	300	300	True

Any help with this will be great.

[wdavis · Accepted solution]

Hi @SMjali 

In this instance, do you need it to match all 3 fields in the individual tables? If so, you could use a join tool which is set to match A&D, B&E and C&F. Then all data that has matched will come out of the J output, whilst anything that hasn't matched and is False would fall out of the L/R output anchors.

You can then use a Union Tool to bring these data sets altogether after assigning them a 'Match' Value in a Formula tool. I have now attached a workflow that would replicate this.

Let me know if this works for you!

Kind Regards

Will

[SMjali · Accepted solution]

Hi @wdavis ,

This is was my first thought. I just maybe wanted to find out that if there was a way to add the Match column in there, to verify that for those two fields we have a match. 

Thank you for the assistance.