AnsweredAssumed Answered

Controling ID during data import

Question asked by navarro on Oct 17, 2016
Latest reply on Oct 18, 2016 by navarro



When adding new records, the auto-enter option of the Import script step starts from 1 without taking into account the ID's of the target table. Is it possible to control it?


For example, let's assume that:


My target table file contains 100 records with ID's ranging from 1 to 100.

My source table file contains 50 records with ID's ranging from 1 to 50.


After adding new records with the Import script step, I get a table can has both the records of the target and source table but:


The first 100 records, originally in the target table, have ID's ranging from 1 to 100.

And, the following added records, coming form the source table, have either their original ID's (if the auto-enter option is unchecked) or they are given IDs raging from 1 to 50 (if the auto-enter option is checked).


So, after importing the new records I get repeated ID's (1 to 50)


Would it be possible to have the first 100 records from the target table have their original ID's (ranging from 1 to 100) and the newly added 50 records having ID's franging from 101 to 150?


If the answer is yes, any ideas how to achieve this?