Subfield only import converted Value

[davyqliks]

Hi,

Hope you can help....

I am using SUBFIELD () to get some data before set value like below:

LOAD  
[Product Code],
SubField([Product Name],'MULTI',1) as ProductName
FROM
[H:\IT\Daniel Lincoln\Portal\Boohoo\data in\*.xlsx]
(ooxml, embedded labels);

but in the table i get the original and the shortened version of the text back.

how can i only get the shortened version back please?

Thanks

Daniel

[melissapluke]

Hi Daniel,

Can you include a screenshot of your data model? 

[rwunderlich]

It looks like it's working on the first row. Are you loading this file twice?

[davyqliks]

HI @rwunderlich @melissapluke 

thank you for the replies,

yes, works on the first line but when i start to add more i get the extra returns.

I have added a where clause linking to a colour code to eradicate this.

Thanks 

Daniel