1 person found this helpful
Take a look at the following discussion Importing multiple amount columns from a single text file
Although it refers to FDM and not FDMEE the same techniques would work with a bit of script modification but should give you more than a good starting point
Thanks SH for your quick answer.
Looks great but complicated as I have to convert it to Jython. Problem is that there're so few ressources regarding FDMEE and Jython. I will however keep on investigating your proposal.
True, there won't be a lot of information out there on specific code transformations such as this, as FDMEE is still a relatively new. Possibly a good topic for one of Francisco's (fishing with FDMEE) next blogs
There is process workaround you could use to achieve the same. Create 2 data load rules, one referencing an import format that picks up the transaction currency value as the amount and one that references an import format that picks up the local currency amount. You can then run these in sequence sourcing from the same data file. Just ensure that the 1st DLR only performs the import, and the 2nd DLR performs the full import / export steps but has the import mode set to Append not Replace.
Thanks Simon for completing your first anwer!
That's a great idea to forward to Francisco Amores. Indeed I put a comment on his blog this morning about Jython choice by Oracle, which in my opinion is nonsense (undocumented and ugly language).
This morning I though indeed in using 2 import formats, I'll have a closer look at it!
Have a nice day.
VBScript is platform dependent...and Jython is not :-) so FDMEE/HFM in unix means you cannot use VBScript.
Jython/Python is very present in the internet. You can find tutorials, blogs, etc...
Going back to managing multiple amounts in one row, there are different ways of approaching this.
The one I prefer is to import the amounts into attribute dimensions and the run the unpivot process in a event script.