Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
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);
thank you!
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);