Skip to main content
Question

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

  • September 24, 2019
  • 3 replies
  • 12 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.

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.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • 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+22
  • Contributor
  • 2179 replies
  • September 24, 2019

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

Hope this helps.


  • Author
  • 1 reply
  • September 24, 2019

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