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: 
davyqliks
Specialist
Specialist

Subfield only import converted Value

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.

davyqliks_0-1614954656139.png

 

how can i only get the shortened version back please?

Thanks

 

Daniel

 

Labels (2)
3 Replies
melissapluke
Partner - Creator
Partner - Creator

Hi Daniel,

Can you include a screenshot of your data model? 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

davyqliks
Specialist
Specialist
Author

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