Skip to Content
0
Former Member
May 10, 2010 at 06:46 PM

Negative Signs added after data is imported

70 Views

Hello

I'm kind of new in BPC to start, but I need to know why is that after the data is imported into BPC (using transformation and conversion files) the data has the negative(-) inserted on all the data.

After doing the import, I verified the transformation file and the output generated is without the negative, but after it's imported the negative is added.

Here's my transformation file...

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=NO

MAXREJECTCOUNT=

ROUNDAMOUNT=

SPECIFICMAPPING= YES

*MAPPING

*CONVERSION

ACCOUNTBENCH=CTA.xls!Conversion

TIME=TME.xls!Conversion

BENCHENTITY=Banco.xls!Conversion

Any help or comment will be appreciated.