Data Exch. Framework: how to use intermediate table?

Belias · 2016-09-09

I am currently working on a data import, and I was wondering why should I use the intermediate table flag in the field mapping. Its functionality is not really clear to me and the documentation about it is really poor imho.
I mean, there’s already an intermediate table where the data is stored (data exch field mapping) and i can’t get why should we use another intermediate table.
In my import I have to do a classical fixed file>”intermediate table”>NAV table(s). I was wondering why and how could I use the intermediate table flag to do the import in the file into my intermediate table, but then I realized that it’s easier for me to set MY intermediate table as the final table, and then work on MY intermediate table during the post-mapping codeunit in order to fetch nav table(s).
Am I missing something?
Thanks in advance for your time

Kishorm · 2016-09-22

It does have a use, just that I didn't need it myself. It was a while back when I looked at it so I don't remember exactly how it worked but one thing I noticed was that when you use that option it allows you to map to mutiple tables in the field mapping section.

Belias · 2016-09-15

I'm trying to bump this once, even if i don't think anybody knows this topic really well

Kishorm · 2016-09-20

I don't think you're missing anything, your suggested method seems fine and is exactly what I have done previously.

Belias · 2016-09-22

So, basically that "use as intermediate table" in the the field mapping header has no use?

Kishorm · 2016-09-22

It does have a use, just that I didn't need it myself. It was a while back when I looked at it so I don't remember exactly how it worked but one thing I noticed was that when you use that option it allows you to map to mutiple tables in the field mapping section.

Data Exch. Framework: how to use intermediate table?

Best Answer

Answers

Categories