0

This might be a stupid question but is there a way to update records (yes many records and duplicate ones) in a DE without a primary key? I am not the owner of the DE which is already structured for several years so I cannot change its fields.

Thanks.

  • In that case your best bet would be to create another DE from this existing DE this way you have better control over your fields [help.salesforce.com/… – Mitesh Feb 6 at 13:24
1

Without a primary key, it's not possible to uniquely identify a row, so you will not be able to update specific records.

The best thing to do is to cease all imports to this data extension, export it and re-import it to a new data extension that has identical fields but at least one primary key that you wish to use to uniquely identify rows in the data extension. You will then easily be able to update this dataset in Marketing Cloud.

An alternative route (if using bulk upload method via SFTP) would be to change your import configuration to 'overwrite'. This would mean sending the entire dataset for each import however.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.