Skip to main content
Solved

FeatureMerger to join 2 excel and remove duplicate rows

gogopotter90
Contributor
Forum|alt.badge.img+13

hello,

i am confused a little bit ,how can i use FeatureMerger correctly.

I have two excel on my workspace ,Excel A : has three rows but one of them is duplicate from Excel B ,and two rows not .

Excel B has 50 rows

i want to merge Excel A with Excel B

and if we have any duplicate row (i mean the one of Excel A) ,remove the duplicates and keep the rest of rows .

so As a result,i need to have Excel that contains 52 rows .

i read alot the Documentation but iam still confused in adjust properties of Featuremerger ,i will be thankful if someone help me .thanks

 

Best answer by robotix

@gogopotter90

Here is how i would do it. In the example I used a source file of 13 rows then copied it and changed 2 rows for the other source. So in the end i should have 15 rows.

The key is to use more that one output from the feature merger and select 'process duplicate suppliers'.

View original
Did this help you find an answer to your question?

8 replies

ebygomm
Influencer
Forum|alt.badge.img+34
  • ebygommInfluencer
  • Influencer
  • January 22, 2020

If i've understood correctly, you should be able to just send features from both A and B to a duplicate filter, and choose whichever attribute(s) are duplicated. No need for a featuremerger at all.

gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • January 22, 2020
ebygomm wrote:

If i've understood correctly, you should be able to just send features from both A and B to a duplicate filter, and choose whichever attribute(s) are duplicated. No need for a featuremerger at all.

i used duplicate filter but there is something data missing but i do not know why.so i think ,i can use feature merger then use remove duplicate .could u hep me if i want to use feature merger and see the difference .bcs duplicate filter something is wrong with me .thanks

ebygomm
Influencer
Forum|alt.badge.img+34
  • ebygommInfluencer
  • Influencer
  • January 22, 2020
gogopotter90 wrote:

i used duplicate filter but there is something data missing but i do not know why.so i think ,i can use feature merger then use remove duplicate .could u hep me if i want to use feature merger and see the difference .bcs duplicate filter something is wrong with me .thanks

Feature merger is not what you want here, as you would only ever get the same number of features out as went into the requestor, you would never get the 52 rows you are looking for

robotix
Contributor
Forum|alt.badge.img+10
  • robotixContributor
  • Contributor
  • Best Answer
  • January 22, 2020

@gogopotter90

Here is how i would do it. In the example I used a source file of 13 rows then copied it and changed 2 rows for the other source. So in the end i should have 15 rows.

The key is to use more that one output from the feature merger and select 'process duplicate suppliers'.

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • January 22, 2020

As @ebygomm said I would use either the DuplicateFilter or the Matcher transformer to remove duplicates, not the FeatureMerger.

robotix
Contributor
Forum|alt.badge.img+10
  • robotixContributor
  • Contributor
  • January 22, 2020
erik_jan wrote:

As @ebygomm said I would use either the DuplicateFilter or the Matcher transformer to remove duplicates, not the FeatureMerger.

DuplicateFilter is easier.

 

gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • January 22, 2020
robotix wrote:

@gogopotter90

Here is how i would do it. In the example I used a source file of 13 rows then copied it and changed 2 rows for the other source. So in the end i should have 15 rows.

The key is to use more that one output from the feature merger and select 'process duplicate suppliers'.

Thanks i will try it

gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • January 23, 2020
ebygomm wrote:

Feature merger is not what you want here, as you would only ever get the same number of features out as went into the requestor, you would never get the 52 rows you are looking for

thanks i used duplicate as u suggested

Reply


Helpful Members This Week

Community Stats

31,231
Posts
118,426
Replies
38,827
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.