7 Replies Latest reply: Mar 16, 2018 8:46 AM by Cherl Zehnder RSS

    Mapping Column names and descriptions

    Cherl Zehnder

      I currently have an excel file attached that will map our database field names to the business names. That works fine.

      [Alias Fields]:

      Mapping LOAD

          OldName,

          NewName

      FROM [lib://AmerisureData/Warehouse\AWHColumnAliases.xlsx]

      (ooxml, embedded labels, table is Aliases);

      Rename Fields using [Alias Fields];

       

      I would like to take it a step further and populate the description of the field as well.  Does anyone have any examples on how to accomplish this?

       

      Thanks in advance