10 Replies Latest reply: Aug 4, 2016 1:45 PM by Thirumala Dandamudi RSS

    change field data on load

    Michael Taylor

      My script is as shown below

       

      LOAD [REC ID],

           Project,

           [Date Created],

           [Date Due],

           [Date Closed],

           Month([Date Closed]) as MonthClosed,

           YearName([Date Closed]) as YearClosed,

           If([Date Closed]> [Date Due],2,1) as Overdue

      FROM

      [M:\test.xlsx]

      (ooxml, embedded labels, table is main);

       

       

      LOAD [PR ID] as [REC ID],

           [Grid ID],

           [Root Cause Tier 1],

           [Root Cause Tier 2],

           [Root Cause Tier 3]

      FROM

      [M:\test1.xlsx]

      (ooxml, embedded labels, table is [Root Cause]);

       

       

      The data in [Root Cause Tier 1] contains a mixture of values

       

      I would like to change all the instances in [Root cause Tier 1] from material to materials

      tried a few options but unsuccessful at the moment.

      Could anyone help out?

       

      many thanks for looking.