Skip to main content
Solved

Comparing two excel tables and find the gaps between them;

  • Jul 20, 2015 10:37 PM UTC
  • 4 replies
  • 55 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
View original
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
  • Jul 21, 2015 5:32 AM UTC
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
  • Jul 24, 2015 4:36 AM UTC
Hi,

 

 

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

lubna_najeh
Forum|alt.badge.img
  • Author
  • Jul 26, 2015 5:44 AM UTC
Hi All,

 

It works with me thank you Pratap

 

 

I will try the second option :)

 

 

Lubna