8 Replies Latest reply: Sep 12, 2013 2:10 PM by Wanderson Marques RSS

    Concat Two Fields

      Hi,

       

      I'm trying to concatenate two fields in my load statement:

       

      BIN:

      LOAD Bin,

           [Last Four],

           concat( Bin&'*****'&[Last Four]) as Card Number

       

      FROM

      [Concat Test.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      My goal's to create a field  'Card Number' by combining 'Bin' and 'Last Four', however, I keep getting sytax errors when I try and load it. I've read a few posts on this and can't see the issue with my script. Any suggestions would be more than welcome.

       

      Thanks in advance for the help.

       

      Matt