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

    Concat Two Fields



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



      LOAD Bin,

           [Last Four],

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



      [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.