topic Load from Excel - Substring in QlikView

Load from Excel - Substring

Thu, 06 Apr 2017 11:09:53 GMT

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 — Thu, 06 Apr 2017 11:16:49 GMT

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 — Thu, 06 Apr 2017 11:20:08 GMT

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

Thu, 06 Apr 2017 11:20:15 GMT

thank you!

sravanthialuval — Thu, 06 Apr 2017 11:21:28 GMT

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