Skip to main content
Solved

Comparing two excel tables and find the gaps between them;


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
Did this help you find an answer to your question?
<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> 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+11
  • 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+11
  • Contributor
  • July 24, 2015
Hi,

 

 

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

lubna_najeh
Forum|alt.badge.img
Hi All,

 

It works with me thank you Pratap

 

 

I will try the second option :)

 

 

Lubna

 

 

 

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