Matching data

[noopurjain]

Hello,

number	code	exp date	Right_number	Right_code	Right_expdate
123456	D25502	12/5/2019	123456	D25502	12/5/2019
123456	D25510	5/14/2022	123456	D25502	12/5/2019
123456	D25502	12/5/2019	123456	D25510	5/14/2022
123456	D25510	5/14/2022	123456	D25510	5/14/2022
456789	D13302	11/29/2019	456789	D13302	11/29/2019
456789	D13302	8/7/2020	456789	D13302	11/29/2019
456789	D13302	11/29/2019	456789	D13302	8/7/2020
456789	D13302	8/7/2020	456789	D13302	8/7/2020

In above dataset when I match exp date != Right_expdate, Alteryx gives me this Which is correct as it is matching the data with in the same row

number	code	exp date	Right_number	Right_code	Right_expdate
123456	D25502	12/5/2019	123456	D25510	5/14/2022
123456	D25510	5/14/2022	123456	D25502	12/5/2019
456789	D13302	11/29/2019	456789	D13302	8/7/2020
456789	D13302	8/7/2020	456789	D13302	11/29/2019

Whereas I wanted no exception when number, code, exp date matched with Right_number, Right_code and Right_expdate, 

[IraWatt]

Hey @noopurjain,

What do you mean by 'no exception'? What is your desired final output?

[noopurjain]

Hello @IraWatt , In case of example I shared I shouldn't be having any row as right side (right_number, right_code, right_expdate) of data matches with left side.

[IraWatt]

@noopurjain would you be able to show the table you want?

[noopurjain]

@IraWatt I have added one more row in original data just to give you an idea of what I want. Check the attached file