6 Replies Latest reply: Sep 19, 2014 1:32 AM by Everardo Mancilla RSS

    RIGHT() / LEFT() Function not working in load script

      Hi,

       

      I am trying to load a column using the RIGHT() function to only take the 6 right-most characters from it's data.

       

      For some reason, when i try to load the script, the column can't be found.

       

      This is the code i am using for the column:

       

      "Right([Functional loc.],6) as SID"

       

      The following is the column in excel:

       

       

      Thew error that i'm getting:

       

       

      I do not want to make a new column in the excel spreadsheet, because i want it to be automated.

       

      Any help would be greatly appreciated.

       

      Matt.