Skip to main content
Solved

FeatureMerger to join 2 excel and remove duplicate rows

  • January 22, 2020
  • 8 replies
  • 64 views
gogopotter90
Contributor
Forum|alt.badge.img+14

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'.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • 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+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • 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.

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+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • January 22, 2020

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
  • 33 replies
  • 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+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • 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
  • 33 replies
  • January 22, 2020

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+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • 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'.

Thanks i will try it

gogopotter90
Contributor
Forum|alt.badge.img+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • January 23, 2020

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

Community Stats

32,078
Posts
121,802
Replies
39,709
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.