Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load from Excel - Substring

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

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

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);

View solution in original post

4 Replies
zhadrakas
Specialist II
Specialist II

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);

Not applicable
Author

thank you!

sravanthialuval
Creator
Creator

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);