Load from Excel - Substring

[#1]

Hi,

Im loading from an external excel data source :

contact_info:

LOAD [First Name],

     [Surname],

     [Email Address]

FROM

(ooxml, embedded labels, table is tdashboard_email_detail);

I need to create a new field during this load resembling : Surname + ' ' + left([First Name],1)  ...

Is this possible at this stage of the load??

Thank you

[zhadrakas · Accepted solution]

Yes, you can use

contact_info:

LOAD [First Name],

     [Surname],

     [Email Address],

     [Surname] & ' ' &  left([First Name],1) as FULLNAME

FROM

(ooxml, embedded labels, table is tdashboard_email_detail);

[sunny_talwar]

Try this

contact_info:

LOAD [First Name],

    [Surname],

    [Email Address],

   Surname & ' ' & Left([First Name],1) as UserID

FROM

(ooxml, embedded labels, table is tdashboard_email_detail);

[#4]

thank you!

[sravanthialuval]

Hi,

try this,

contact_info:

LOAD [First Name],

     [Surname],

     [Email Address],

  [Surname] & '  ' &left([First Name],1) as Name

FROM

(ooxml, embedded labels, table is tdashboard_email_detail);