Matching rows in Alteryx

Question

Hello All,

I want to create a workflow where code, code2 and quality is same but the Amount is different. My output should have yellow highlighted fields.

In the example, 1st set of data is from row 2 to row 9.  I want row 2 as it appeared multiple times. Therefore, I want to keep it as a reference in my output. And then I want row 8 and 9 as these amounts are different from row 2.

matching rows.xlsx

Vaithi · Answer

Hi @noopurjain ,

Attached is the Simple workflow with the expected result.  Hope this helps 🙂

Regards,

Vaithi

Matching solve.yxmd

shreyanshrathod · Answer

Hi @noopurjain ,

The attached workflow should help.

I am assuming your single entries are determined by code and code2 columns. If any more columns determine single entry, kindly add those to the Summarize and Join tool respectivrly.

Hope it helps.

Regards,

Shreyansh

New Workflow2.yxmd

New Workflow2.yxzp

noopurjain · Answer

Thanks! Now I have unique rows.

I am still having lots of data in exception. Is there any way I could delete single entries from my output. For reference, I have added few more rows in the example.

matching rows.xlsx