cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hi,

Is there document on how to read data from spreadsheet using data services? I need to read certain rows and columns in a sheet and cannot find instruction on how. I know IBM data stage can do this.

Thanks!

0 Likes
View Entire Topic
0 Likes

Hi Lina,

Here's a pretty good blog to get started on how to import from an Excel file.

https://blogs.sap.com/2012/12/26/how-to-import-an-excel-file-in-data-services/

Once you are able to read the excel, you can then filter according to your needs.

Regards,

Sid