Skip to Content
0
Former Member
Apr 28, 2009 at 04:38 PM

Extraction from excel file

75 Views

Hi experts,

I have never extracted from an excel before, i have always got the data from R3 but now I need to do this, so i am a little lost.

I have created a source system named FLATFILE. From there i have created a data source. The problem is this: The file has not the fields exactly as I want, and i need to change some data and make some filters. So in the field section, do i need to put the fields that i need or only the ones from the file???

The transformations and all this things i have to do t in the transformation between the data source and the destination or in the routine of the data source?

Thank ypu very much,

Artur.