3 Replies Latest reply: Aug 28, 2017 1:38 PM by Sunny Talwar RSS

    Mapping Table Dropping Fields

    Erica Trotter

      Hi, I am trying to drop fields while also renaming. All the fields I do not want are renamed as numbers, I tried to create an if statement that would drop the unwanted fields but it is not working. Let me know if anyone has any ideas!

       

      Here is my script:

       

      Initiative__c:

      LOAD

      *;

      Select *

      FROM Initiative__c;

       

       

      FieldMapInitiative__c:

      MAPPING

      LOAD Field,

           Rename

      FROM

      [lib://AttachedFiles/FieldMap.xlsx]

      (ooxml, embedded labels, table is Initiative__c)

      WHERE len(Rename)>0

      & if(Field=num(0-100),drop);

       

       

      Rename Fields using Initiative__c;