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

Steps:

  • Open Data services
  • Create a new job
  • Create a new dataflow – drag & drop from the menu on the right
  • Add the data source table , using drag & drop from the datastore area.
  • Add a query item using drag & drop from the menu on the right
  • Add a Reverse Pivot object from the transform/platform area
  • connect Source table to the Query object, connect the query object to the Reverse Pivot object
  • Add a query item using drag & drop from the menu on the right.
  • Add a template as a Target, using drag & drop from the datastore area, Name the table & select the data store in which it needs to be created.
  • Connect the Reverse Pivot Object to the Second Query object & the Second Query object to the template table target object.
  • Open the First query object, drag & drop the columns required to the output area.
  • Open the Reverse Pivot Object and Drag & Drop the Non Pivot Columns , Pivot Columns and the Value of the Pivot Axis Columns . Enter the Axis
  • Values & their respective Column Prefixes .
  • Open the Second query object, drag & drop the columns required to the output area, Rename the columns in the Output window as required .
  • Validate & Run the Job .
  • View the output Table data to confirm