Skip to main content
Question

How do i compare data rows from two tables accross two databases?

  • September 24, 2019
  • 3 replies
  • 5 views

How do i compare data row count from two tables across two databases? Basically i am trying to load data if source has more rows than target table.

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • September 24, 2019

Hi @rajan

 

Did you try to use the transformer FeatureMerger to compare?

 

Thanks in Advance,

Danilo

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • September 24, 2019

I created a workspace (without the data) that shows the workflow:

Hope this helps.


  • Author
  • September 24, 2019

Thanks a lot for 1=1 trick was getting two separate rows and that was chocking point.


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