Question

Transform data

  • 12 October 2022
  • 3 replies
  • 39 views

Badge +2

Hi

I need to setup a fileimport with finance information. The file going to be imported with the External File assistant. i have created a External File Template with the ExtVoucher filetype.

This works great, but i need some of the data to be changed during the import, there is some codes that is different in the file and need to be translated to the IFS spesific codes. How can this be done?

Using Enterprice Explorer IFS10


3 replies

Userlevel 6
Badge +14

You are able to establish detail functions.   in IEE, RMB on the detail line.   In Aurena, access via the ‘detail’ dots.

 

Badge +2

You are able to establish detail functions.   in IEE, RMB on the detail line.   In Aurena, access via the ‘detail’ dots.

 

Thanks for the answer, I got it working with the replace function. Then i have to make a new line for each value. Is there a better way

 

Userlevel 6
Badge +14

I always go for the easy button (sounds like you found it).   It could be possible to do it with one conditional line but I like the practice of keeping them separate for easy edit later.

Reply