Skip to Content
0
Sep 19, 2012 at 03:07 PM

Mapping: Removing single rows, leaving duplicates

17 Views

Hi,

I have a particular problem. I have an input file that contains groups of records. There should be two records for each vendor. However, some have just one. What I want to do is exclude those vendors that only have one records

INPUT

VENDOR #
TYPE
NAME123456AXXXXX123456BYYYYY908976BGGGGG334567AGGGGG334567AGGGFD123321BFDSSSS

OUTPUT

VENDOR #TYPENAME123456AXXXXX123456BYYYYY334567AGGGGG334567BGGGFD

is there any way this can be done with a simple mapping or do I have to use a UDF

Many thanks

Rob