This tutorial shows you how to use the Pivot 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 Pivot object from the transform/platform area
- connect Source table to the Query object, connect the query object to the Pivot object
- 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 Pivot Object to the template table target object.
- Open the query object, drag & drop the columns required to the output area.
- Open the Pivot Object and Drag & Drop the Non-Pivot Columns & the Pivot Columns
- Validate & Run the Job.
- View the output Table data to confirm
