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.