Filtering the unique records based on record id

Question

Hello there,

I have this requirement as mentioned below :

VendorPay term Invoice Record id V1P111V2P121V2P231V2P242V1 P152V1 P163

Solution need to filter the records which are repeating more than once. For example above : V1 P1 combination is repeated 3 times . So 3 records of V1 P1 need to taken to output . Any idea how to do this .

Thankyou .

alexnajm · Answer

Hi @praneshsapmm,

I would use a Summarize tool to count the number of instances of the Vendor-PayTerm combination, then filter that down to where the count equals 1. When you join this back to the original data on those key fields, you'll be left with only those records with a count of 1. You could also do that Filtering after the join if you wanted to.

You could also use a Tile tool to complete a similar process.

-Alex

Filter out Duplicative Records.yxmd

MilindG · Answer

@praneshsapmm

Can you do something like the attached workflow?

Filtering.yxmd

praneshsapmm · Answer

Hi @MilindG ,

I need V1 P1 to be filtered out .

Thanks.