The found set has to be selected on the file A before to import from it.
Thanks - I was under the impression that I could generate the found set to import by doing a find in the interface file.
You can - if you import from the interface file. The found set has to be present in the source file (the file from which the import is conducted).
Can you please clarify that as I'm confused now. I'm trying to do the find/import in the Interface file. First I switch to a layout in the interface file that is based on a table occurrence for the source file and get my found set.
I then switch to a different layout in the interface file based on a local table in the interface file to do my import - how do I get it to target the found set I created on the first layout?
Make your source file the interface file ( i.e. the same file). The source table is the TO in the interface file that has the found set (where you started). The destination table is where you are now.
The key is realizing you're importing from and to the same file, despite the fact that the data live in another file. That's what makes it work.
1 of 1 people found this helpful
To get the found set you want, you need to be careful about the source table of the import.
If you do the Find in the interface file (File B), you need to select File B as the file you are importing from. You then select the external table occurrence (that you used to do the Find) as the source 'table' for the import.
It is slightly couterintuitive at this point. You think to yourself "I'm importing from File A, so I need to select it as the file to import from". But actually you're importing from one table to another in your interface file, it's just that the source table happens to be externally stored.
I hope that has made it clearer.
Thanks Mike - that was the missing piece, making the file I'm importing from the interface file not the source file.
Thanks Rob - that was the missing piece I was looking for.