Unable to mark duplicate records using Multi-Row formula Tool

Hello Alteryx Community Users,

When I use 2 Multi-Row formula tools in conjunction and try to mark as "Dup" by adding a new field 'Duplicate' based on two key field values check, workflow is not retaining and/or marking all duplicate records as expected. I see it marking it partially where as I expect both Customer "BBB" and "DDD" 4 records in total (NOT 2) be marked as "Dup".

Here I am attaching the test sample workflow that I am facing the problem with.

I appreciate any insight into how I can get this problem solved.

Input Data:

Credit Line # Customer
AAA-20190714-USD AAA
ABC-20190714-USD ABC
BBB-20190714-EUR BBB
BBB-20190714-EUR BBB
CCC-20190714-EUR CCC
DDD-20190714-USD DDD
DDD-20190714-USD DDD

Duplicates_Identifying_Autosave-v2.yxmd

Developer Tools

Accepted answers

I adapted your first multi-row tool to mark both as duplicate fields.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-16 Duplicates_Identifying_Autosave-v2.yxmd

All comments

@jramidi Your second mutli-row formula needs a minor change!

You should use this:

IF [Customer]=[Row-1:Customer] AND [Credit Line #]=[Row-1:Credit Line #]THEN "Dup" ELSE [Duplicate] ENDIF

rather than:

IF [Customer]=[Row-1:Customer] AND [Credit Line #]=[Row-1:Credit Line #]THEN "Dup" ELSE "" ENDIF

Does this work for you?

@jramidi I attached a dynamic version of what you are trying to achieve as if the duplicates aren't sorted, it won't be caught as a duplicate! 🙂

Duplicates_Identifying_Autosave-dynamic.yxmd

I adapted your first multi-row tool to mark both as duplicate fields.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-16 Duplicates_Identifying_Autosave-v2.yxmd

Hi Digan,

Thanks for your response. It did worked for me.

Hi Fernando,

Yours is a much simpler solution. Thanks a lot for your response.

Quick Links

Tags

This months top contributors

Hollingsworth 335