AnsweredAssumed Answered

Controling ID during data import

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

Hello,

 

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?

 

Thanks

Outcomes