6 Replies Latest reply: Aug 29, 2013 1:33 PM by Todd Kaiser RSS

    Left join based on a period

    Todd Kaiser

      Good day.  Trying to join some information based on fields that are not unique.  So what would the script be to separate it out.

       

      162.3.  Where everything before the first period is what I want to call Task List ID.  Everything between the periods I want to call Task Number.

       

      So I want to separate based on the periods.  The two files are Excel so when I load the files.  This field comes in as xls. rather than delimited type.