SAP BO Data Services Tutorial: loading multiple files

This tutorial shows you how to load multiple files 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 the two File formats, using drag & drop from the File format tab.
• Open the File Formats and provide the file names.
• Add a merge object from the transform/platform area.
• Connect the Two file formats to the merge Object.
• Add a Template Table from the Menu in the Right, Enter its name & the select the data store where it needs to be created.
• Add a query item using drag & drop from the menu on the right
• connect Merge object to the Query Object & Query object to the template table.
• Open the query object, drag & drop the columns required to the output area.
• Validate & Run the Job.
• View the output table data to confirm