Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have the attached excel, and I need to get the "Licensed Products for Account" field to show values individually, because now it is one long string.
It is delimited on the | character
I need to do this in the script.
Any ideas?
Hi Aaron,
Use something like this
data:
LOAD [DMSi Customer ID],
SubField([Licensed Products for Account],'|') as [Licensed Products for Account],
[NPS Owner],
[NPS Owner Date],
[NPS Sys Mgr],
[NPS Sys Mgr Date],
[Type of Site]
FROM
(ooxml, embedded labels, table is Export);
Felipe.
Hi Aaron,
Use something like this
data:
LOAD [DMSi Customer ID],
SubField([Licensed Products for Account],'|') as [Licensed Products for Account],
[NPS Owner],
[NPS Owner Date],
[NPS Sys Mgr],
[NPS Sys Mgr Date],
[Type of Site]
FROM
(ooxml, embedded labels, table is Export);
Felipe.
I figured it was with subfield. Thanks!