3 Replies Latest reply: Mar 11, 2015 11:24 AM by Puttemans Johan RSS

    join based on concat of two fields

    Todd Kaiser

      I have a data set where I want to join to another data set by the concat of two fields.

       

      example

       

      MATERIALSAP REV ROWconcat
      123456A123456A

       

      so the concat field is what I would join the other table with.  I was thinking that I do this in the script upon the load...rather than load it twice