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 Management - loading Debit and Credit using delimited file

edited Dec 13, 2024 5:59AM in Financial Consolidation and Close 2 comments

Hi All,

I am able to load credit and debit from Delimited file in Data management using the below SQL but one of the issue i am seeing is change sign is not applying because we are directly setting the target amount. could you please advise on how to resolve the change sign issue.

AMOUNTX =

CASE
WHEN ATTR1 IS NULL THEN

CASE
WHEN REGEXP_LIKE(REPLACE(REPLACE(ATTR2, '"', ''), ',', ''), '^-?\d+(.\d+)?$') THEN TO_NUMBER(REPLACE(REPLACE(ATTR2, '"', ''), ',', ''))
ELSE 0 -- Handle cases where ATTR2 is not a valid number

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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