Merge identical documents/files

Discussion created by paulvw on Nov 18, 2016
Latest reply on Nov 19, 2016 by Johan Hedman

I have many identical documents/files with different data. The files are 100% identical (lay-out, fields, relationships, portals etc) as they have been copied a number of times. Now I need to merge them all in one.

I thought it was a simple process by using the IMPORT RECORDS under FILE and simply add each document to a source. Yes, it works but the PORTALS data do not import and stay empty (without data). I thought that it is a matter of changing the related tables in TARGET so it would be identical to the SOURCE (when using IMPORT RECORDS) but those are all grayed-out.

What is the easiest and best way to merge or import identical files?