Skip to main content
  • EN

Hello,

I'm looking the better way and automatic to do this.

I have two Databases ( Oracle and Microsoft SQL Server Spatial ) and need to compare the datas between the two tables:

The tables has 80 attributes in common ( with the same name ) and need to merger, i think to use the transformer FeatureMerger.

My question is: Need i to select manually in FeatureMerger the attributes Requestor and Supplier to 80 attributes?

*Example with just 3 attributes add manually

 

 

Thanks,

Danilo

If two table have same attribute names and case,You can select the first 79 attributes in Group By,then set Requestor to Supplier with the last attribute. If the attribute names or case of the two tables are different, you can rename them first.

Why not use the Matcher? In particular, look at the "Attribute matching strategy" setting.

If two table have same attribute names and case,You can select the first 79 attributes in Group By,then set Requestor to Supplier with the last attribute. If the attribute names or case of the two tables are different, you can rename them first.

Hi @taojunabc, thanks your typ. It was interesting and its works!

 

 

Thanks,

 

Danilo

Why not use the Matcher? In particular, look at the "Attribute matching strategy" setting.

Hi @david_r,

 

Thanks your help:)

 

Reply


Community Stats

30,190
Posts
114,589
Replies
37,854
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.