You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Sign Flip based on Account attribute

in EPM Platform and Freeform 3 comments

Summary:

Hi,

I'm writing a SQL map in Accounts to flip the sign of data being imported based on value of an account attribute. If the value for the attribute says 'Flip' then the data for that account should get flipped. This is the query i'm using

AMOUNTX =
CASE
WHEN AccountTypeSignFlip = 'Flip' THEN AMOUNT * -1
ELSE
AMOUNT
END

While importing data, getting below error

ERROR [AIF]: Unexpected error: <type 'java.lang.RuntimeException'>
java.lang.RuntimeException: Invalid column index

Any inputs regarding how to resolve this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!