Rename Column Headers on Export

  • 136Views
  • Last Post 27 June 2019
Vindico Medical Education posted this 26 June 2019

How can we choose what column header names to utilize on a CSV export?

Right now, when reading from Salesforce, it automatically formats in: Object.FieldName which is causing us problems when using the CSV file in a Store Procedure.

Dmitriy Muzurov posted this 27 June 2019


Thank you for submitting a ticket with us.

It is not possible to rename columns from client side. At the moment, we can propose you the following option: you tell us package number, specify the objects and columns you want to rename and their desired names. For example:


Account object:

AccountId - > "AccountId_Test"

Name - > "TestName", etc.

Or you can compose it in the SQL format:

"SELECT t.Id as "IdMain", t.OwnerId, t.IsDeleted, t.Name as "NameMain", t.CreatedDate, t.CreatedById, t.LastModifiedDate, t.LastModifiedById, t.SystemModstamp, t.Ext__c as "Test" FROM Account AS t"

After this, we will change SQL that is used for execution of your Export package according to your goal.

We are looking forward to hearing from you.