Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am using the following to take everything after the search value ('ORANGE' in this example)
I need this to be case sensitive but it is not.
How can i achieve this please?
Load
SubField([Product Name],'ORANGE',1) as ProductName,
[Product Code]
FROM [\\uk1-file01\Office-LabUK\Sales\Boohoo\Portal\Data files\QVD\dataload.qvd(qvd)] (qvd)
WHERE WILDMATCH(ColourCode,'152');
Is there any way to achieve this?
Example - this value
Multi Satin Wide Leg Trouser MULTI-8
is returning the same when i should just get this
Multi Satin Wide Leg Trouser
thank you in advance.
Daniel
Subfield() is case-sensitive - at least in QlikView and there is no reason why it should be different in Sense. Therefore I suggest that you check your field-values and the used functions/syntax again if they are look like expected respectively are applied properly.
- Marcus
Confirmed that Subfield() is case sensitive in Qlik Sense as well. If you are separating based on 'ORANGE', why would you expect it to recognize 'MULTI' as a separator?
Hi,
May be try
Load
SubField(UPPER([Product Name]),'ORANGE',1) as ProductName,
[Product Code]
FROM [\\uk1-file01\Office-LabUK\Sales\Boohoo\Portal\Data files\QVD\dataload.qvd(qvd)] (qvd)
WHERE WILDMATCH(ColourCode,'152');
Can you upload here some sample/dummy data?
with your exact output whatever you want
Subfield() is case-sensitive - at least in QlikView and there is no reason why it should be different in Sense. Therefore I suggest that you check your field-values and the used functions/syntax again if they are look like expected respectively are applied properly.
- Marcus
Confirmed that Subfield() is case sensitive in Qlik Sense as well. If you are separating based on 'ORANGE', why would you expect it to recognize 'MULTI' as a separator?
Hi,
May be try
Load
SubField(UPPER([Product Name]),'ORANGE',1) as ProductName,
[Product Code]
FROM [\\uk1-file01\Office-LabUK\Sales\Boohoo\Portal\Data files\QVD\dataload.qvd(qvd)] (qvd)
WHERE WILDMATCH(ColourCode,'152');
Thank you so much for taking the time to reply.
As mentioned seems it is caps sensitive ( i made an error in a lookup) but thank you for the information. good to know about the Upper() function, thanks
Daniel