Grouping vendors by duplicate price values

[jd12]

I am trying to get duplicate values for vendors to show up as separate line items. 

Say Vendor A had 6 transactions throughout the year and 4 of them are for $10 each and the other two are for $546 and $246.  I only want my output file to show the 4 transactions that were for $10 but each of them to be on their own line.

[BenMoss · Accepted solution]

I believe there are a few macros on the public gallery that do this, but anyhow I'll show you how I would so it...

Use a summarize tool, grouping by the vendor and grouping by the value field. Also perform a count, this can be on any field.

Then after your summarize, add a filter tool to only keep records that have a count greater than one.

Then, take this true stream, and join it against your initial data stream on Vendor and Value.

Then you should have transactional level data, that contains only your duplicates.

Ben

[jd12]

Thank you BenMoss!