Rename Column Headers on Export

  • 10Views
  • Last Post 3 weeks ago
0
votes
Vindico Medical Education posted this 3 weeks ago

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.

0
votes
Dmitriy Muzurov posted this 3 weeks ago

Hi,

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:

Package

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.

Close