Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

FDMEE - how to load two columns to make a net amount into amount

Teresa ModestaApr 25 2019 — edited Apr 25 2019

Hi,

I have a file which gives me a Debit and a Credit column and I need to load Debit - Credit to the Amount using FDMEE.

I thought I could do this with two loads, but after trialling various settings of append / addition on loading I do not get the net result I get if I manually add the two columns and just load the result.

Is there a way to do this with a single load without manually editing the source file?

thank you!

Teresa X.

This post has been answered by JohnGoodwin on Apr 25 2019
Jump to Answer
Comments