Skip to Content
Jan 17, 2019 at 10:57 AM

Compare data A&B to data C&D

122 Views Last edit Mar 06, 2019 at 04:59 PM 2 rev

I have 2 variables - VR1 & VR2 and want to return a value that shows matches between V_MAN & V_MIN.

The idea is to data load the mismatches


VR1 = A V_MIN = A

VR2 = B V_MAX = D

So I know VR1 is = V_MIN do I need to do a variable saying if VR1 - V_MIN then "MATCH" else "NO" or if VR1 =V_MAX "SECOND MATCH" else "NO" or if VR2=V_MIN then "MATCH" else "NO and so on. The variable doesn't seem to like my syntax. Can I do this all in one variable to leave to columns of results?