Skip to main content
Solved

Compare between two seperated excel file with common is extract the missing data from another file

gogopotter90
Contributor
Forum|alt.badge.img+13

I would like to ask ,if I have four excel file

I want at first to compare between two attributes ,Id attribute ,both of them should have the same attribute but some times one excel file has more than another.

So ,I would like to check which has more and

If first excel file has more than the second excel file so I want to know the new id and extract for each new Id from the third file the data in this row belongs to this id.

 

And at the same time If the second file has more id than first time ,so I would like to extract know which Id is more in second file and add them to first file and extract the data from the fourth excel file .

So I want both of excel file ,first and second should be matched in Id and each one extract the missing data from separated file .

Because only common between first and second is Id and the rest of data from another two files

Best answer by bwn

Use 3 FeatureJoiners:

  1. FeatureJoiner 1: Join Excel#1 to Excel#3 - JOIN field is ID
  2. FeatureJoiner 2: Join Excel #2 to Excel #4 - JOIN field is ID
  3. FeatureJoiner 3: Join FeatureJoiner1 to FeatureJoiner2 - JOIN field is ID

From the output of FeatureJoiner3:

  • Joined Port: All common data rows between Excel#1 and Excel#2
  • UnjoinedLeft: All data rows in Excel#1 that do not exist in Excel#2
  • Unjoined Right: All data rows in Excel#2 that do not exist in Excel#1
View original
Did this help you find an answer to your question?

3 replies

bwn
Evangelist
Forum|alt.badge.img+26
  • bwnEvangelist
  • Evangelist
  • Best Answer
  • March 13, 2020

Use 3 FeatureJoiners:

  1. FeatureJoiner 1: Join Excel#1 to Excel#3 - JOIN field is ID
  2. FeatureJoiner 2: Join Excel #2 to Excel #4 - JOIN field is ID
  3. FeatureJoiner 3: Join FeatureJoiner1 to FeatureJoiner2 - JOIN field is ID

From the output of FeatureJoiner3:

  • Joined Port: All common data rows between Excel#1 and Excel#2
  • UnjoinedLeft: All data rows in Excel#1 that do not exist in Excel#2
  • Unjoined Right: All data rows in Excel#2 that do not exist in Excel#1
gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • March 13, 2020
bwn wrote:

Use 3 FeatureJoiners:

  1. FeatureJoiner 1: Join Excel#1 to Excel#3 - JOIN field is ID
  2. FeatureJoiner 2: Join Excel #2 to Excel #4 - JOIN field is ID
  3. FeatureJoiner 3: Join FeatureJoiner1 to FeatureJoiner2 - JOIN field is ID

From the output of FeatureJoiner3:

  • Joined Port: All common data rows between Excel#1 and Excel#2
  • UnjoinedLeft: All data rows in Excel#1 that do not exist in Excel#2
  • Unjoined Right: All data rows in Excel#2 that do not exist in Excel#1

Thanks ,i will try ur method today and tell the result

gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • March 13, 2020
bwn wrote:

Use 3 FeatureJoiners:

  1. FeatureJoiner 1: Join Excel#1 to Excel#3 - JOIN field is ID
  2. FeatureJoiner 2: Join Excel #2 to Excel #4 - JOIN field is ID
  3. FeatureJoiner 3: Join FeatureJoiner1 to FeatureJoiner2 - JOIN field is ID

From the output of FeatureJoiner3:

  • Joined Port: All common data rows between Excel#1 and Excel#2
  • UnjoinedLeft: All data rows in Excel#1 that do not exist in Excel#2
  • Unjoined Right: All data rows in Excel#2 that do not exist in Excel#1

thanks alot ur method works as charm

could i ask i want to add new row to the column so i used uncondition featuremerger but it seems does not work to me ,i do not know why i got output from merged 14 and used supplier 1 so it did not add .what should i do bcs i have now common attribute but no common field just i want to add one row to another table and thanks

Reply


Helpful Members This Week

Community Stats

31,313
Posts
118,736
Replies
38,899
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.