Skip to Content
0
Former Member
Feb 08, 2011 at 06:48 AM

skip columns in transformationfile

16 Views

Hi

We are running BPC NW 7.0

From SAP we get a flat file withthe following layout:

dimension;dimension;dimension;dimension;dimension;dimension;jan;feb;marts;april;may;june;july;august;september;okt;nov;dec;

The file has header.

We now have a need only to load fx figures for april.

I want to fix that in the transformation/ and - or conversionfile.

Anyone who knows a solution?

I want to avoid a reprogramming of the extract from SAP. And we are running this by FTP so I will not interphere in the process and do something in Excel with my file. I have this way to load app 80 files every night.

Kind regards