Mapping salesforce fields with list

[nix1]

I have loaded multiple individual Salesforce fields and now want to rename each field using a single excel table.

I have tried mapping but because the individual fields are separate data tables, do I have to map each one individually?

LIB CONNECT TO 'Salesforce_BULK';

LOAD 

ApplyMap('Salesforcenames_TempMap', "LS Component", null()) as "Short names",
LS_1a_CAP_Compliant__c,
LS_1b_CCRA_Compliant__c,
LS_1b_GPC_Compliant__c,

[Salesforcenames_TempMap]:

Mapping LOAD
// "LS Component",
// "Short names"
// FROM [lib://AttachedFiles/LS clean data.xlsx]
// (ooxml, embedded labels, table is [Short names]);

[ArinaRay]

You should use ApplyMap for each field if it necessary.

If you want to rename the LS_1a_CAP_Compliant__c field using the mapping, just use the mapping table you created earlier

ApplyMap('LS_1a_CAP_Compliant__c', 'LS Component', null())  as [Your_name]

[Kushal_Chawda]

@nix1  can you please elaborate?