Switching field values in bulk

[KT_CD]

I uploaded a list that had company name and job title values switched (example: Job Title: Google, Company: Marketing Automation Manager). Is there anyway to run a retrofix in bulk for this?

[SanfordWhiteman · Accepted solution]

Not built-in. You could use a webhook-enabled service to do this, but if you can just change the CSV and re-merge only those fields you might as well do that. 

[Michael_Florin]

Or: You use a third field as temporary bucket.

Change Data Value: TempField = {{lead.Job Title}}

Change Data Value: Job Title = {{company.Company Name}}

Change Data Value: Company Name = {{lead.TempField}}

[Darshil_Shah1]

I'd just swap the Company Name and Job Title column headers in the CSV file, remove other columns except for Email Address (assuming you haven't changed your de-duplication field for the list import by reaching out to Marketo support), and re-upload the list. 🙂