Skip to main content
Solved

Comparing two excel tables and find the gaps between them;

  • July 20, 2015
  • 4 replies
  • 12 views

lubna_najeh
Forum|alt.badge.img
Hi All,

 

I have 2 table and I want to find the gap between them and join them in one table to better comparison and presentation of gaps 

 

 

 

Can I do this comparision using FME?

 

 

Thank you,

 

Lubna

Best answer by pratap

Hi,

 

 

Yes, with the help of Feature Merger Transformer. 

 

 

Merged, Not Merged and Unreferenced ports have to considered for the output.

 

 

I have observed that Headers are changed in Output. V1 which is Numerical in input have changed to Alphabets. If it is required then additional attribute creator is requird to change the header.

 

 

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

4 replies

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • Best Answer
  • July 21, 2015
Hi,

 

 

Yes, with the help of Feature Merger Transformer. 

 

 

Merged, Not Merged and Unreferenced ports have to considered for the output.

 

 

I have observed that Headers are changed in Output. V1 which is Numerical in input have changed to Alphabets. If it is required then additional attribute creator is requird to change the header.

 

 

Pratap

Forum|alt.badge.img
I'm no't sure, but maybe, a ChangeDetector could be a option. You can create features per each table and use them as inputs int he transformer.

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • July 24, 2015
Hi,

 

 

Is it not solved with my previous suggestion above???

lubna_najeh
Forum|alt.badge.img
  • Author
  • July 26, 2015
Hi All,

 

It works with me thank you Pratap

 

 

I will try the second option :)

 

 

Lubna