cancel
Showing results for 
Search instead for 
Did you mean: 

Tranformation Files - Easy Question - Please Help

Former Member
0 Kudos

I have a transformation file that I am using to load a full year data file. I have one account that I need to flip the sign on. The proper formula is in the conversion file for this account. When I run the package to import the data, the sign only flipped for the first month, not for all 12 months. Obviously, I have an incorrect formula somewhere.

In the Conversion file, my formula is value*-1

In my Transformation file, I have the CONVERTAMOUNTWDIM= specified in the first section

I have Time=*MVAL(3:14) to indicate the 12 months of data in my file in my options

I have Amount=FRCST Conv.xls!frcstacct and TIME=FRCST Conv.xls!frcsttime for the amount formula in the conversion section

I believe the problem is possibly that I don't have amount specified in the options section but I am not sure what formula.

I am sure I am overlooking something simple, any ideas are definitely welcome.

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

former_member190501
Active Contributor
0 Kudos

Hi,

Where did you put the formula value*-1? If you put this formula in account conversion file then maintain transformation as follows :

*Options

CONVERTAMOUNTWDIM=c_accnt "Account dimension

CREDITPOSITIVE=NO

*Mapping

Time=*MVAL(3:14)

..

.....

*Conversion

amount=<account conversion file>.xls

c_accnt=<account conversion file>.xls

hope it helps...

regards,

Raju

Former Member
0 Kudos

FORMAT = DELIMITED

HEADER = no

DELIMITER = ,

SKIP = 3

SKIPIF =

VALIDATERECORDS=YES

CONVERTAMOUNTWDIM=ACCOUNT

CREDITPOSITIVE=NO

MAXREJECTCOUNT=10000

ROUNDAMOUNT=

*MAPPING

Account=*col(2)

AcctDetail=*col(2)

Category=*NEWCOL(budget)

DataSrc=*NEWCOL(source)

Entity=*col(1)

Intco=*col(2)

Rptcurrency=*NEWCOL(lc)

Time=*MVAL(3:14)

*CONVERSION

Account=FRCST Conv.xls!frcstacct

AcctDetail=FRCST Conv.xls!frcstacctdetail

Amount=FRCST Conv.xls!frcstacct

Entity=FRCST conv.xls!frcstentity

Intco=FRCST Conv.xls!frcstacctinterco

TIME=FRCST Conv.xls!frcsttime

datasrc=FRCST Conv.xls!frcstds

The above is the set up of my transformation file. I realize I didn't specify this in my first e-mail but the only month that the formula is working for is the first month. The other months are still showing up as negative. I do have the formula in the Account dimension. Is there anything else that I need to specify so the formula applies to all the data being loaded, not just the first month?

Thanks!

Answers (1)

Answers (1)

Former Member
0 Kudos

Still wondering if there is a way for this formula to work for 12 months vs. 1 month at a time as it is currently doing. Thanks.