Skip to main content
  • EN

I have to tables from ms sql server.

table A: Task_posting

table B: Task_analysis

 

They are joined by the transaction_id field.

 

Now I need to get all Fields from A and add line_cost, Line_qty and Line_unit from B.

 

What transformer is the best for this? I tried to use databasejoiner, but in the section "fileds to add" I cannot find the fields from table B

 

The DatabaseJoiner would be an obvious choice but you'll need to connect that to the SQL Server database before you can see tables/fields.

 

If you already have both tables as feature types in Workbench you can use a FeatureMerger or FeatureJoiner.

Reply


Community Stats

30,159
Posts
114,479
Replies
37,802
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.