Forum Discussion
QuentinFleischf
5 years agoQrew Cadet
Thanks Mark,
Appreciate the quick response.
Am I in essence importing the table over the top of itself?
I have had a quick look and I am assuming the following is the case:
1. Go to required table (Table A), select import/export, select import from another table.
2. On the create new import set the source table as Table A.
3. Set import type to merge in Table A and set the key field for Table A as both the merge key field and source field.
4. Could I at this point under matching only import tasks where Field A is not equal to Field B (or would you recommend against this?)
5. Under field mapping under default mapping it only says 36 fields will be copied. I assume only fields of a certain type (?) can be imported as I definitely have more fields... I will, per your suggestion, only update Field A / Field B by invoking custom mapping on that field.
Again, thank you for the assistance.
Appreciate the quick response.
Am I in essence importing the table over the top of itself?
I have had a quick look and I am assuming the following is the case:
1. Go to required table (Table A), select import/export, select import from another table.
2. On the create new import set the source table as Table A.
3. Set import type to merge in Table A and set the key field for Table A as both the merge key field and source field.
4. Could I at this point under matching only import tasks where Field A is not equal to Field B (or would you recommend against this?)
5. Under field mapping under default mapping it only says 36 fields will be copied. I assume only fields of a certain type (?) can be imported as I definitely have more fields... I will, per your suggestion, only update Field A / Field B by invoking custom mapping on that field.
Again, thank you for the assistance.