This tutorial shows you how to use the Merge operation in SAP BO Data Services.

Steps:

  • Open Data services
  • create a new job
  • Create a new workflow – drag & drop from the menu on the right
  • Create a new dataflow – drag & drop from the menu on the right
  • Add two regular tables as the source, using drag & drop from the datastore area. They have to have the same columns (names & type)
  • Add a query item using drag & drop from the menu on the right
  • Add a merge object from the transform/platform area
  • connect the two template tables to the merge object, connect the merge object to the query object
  • create a template table as the output table
  • Open the query object, drag & drop the columns to the output area
  • Optionally view the source tables content for testing purposes
  • Run the job, view the output to confirm