Any one please help me to update column name from _ContactKey to ContactKey i.e removing the _(underscore) through query activity in marketing cloud.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
In your Query Activity, you will need to use an SQL alias to rename the column heading to match the ContactKey field in your target Data Extension. For example:
SELECT _ContactKey AS ContactKey, Field1, Field2, Field3 FROM DataExtensionName
FieldN with the other fields required in your query.