CODEWITHSUNDEEP
qlikviewloaddata
Ves
Ves

Reputation: 21

qlikview MapSubString

I am using mapping load with MapSubString but it doesnt work for searching the sentence start and ends with text. For example : All below cases will be mapped with Network fault.

So the search must be something like Network*fault I cannot make it with wildmatch because i have around 280 keywords to be searched.

Thanks in advance

Keywords:
Mapping load Upper(Keyword) as Keyword, '$' &Todo& '~' as Todo
FROM [$(ROOTPATH)\Config\projects\$(vPROJECTNAME)\Ticket_Defect_Keyword.xlsx]
(ooxml, embedded labels, table is Sheet1);

load ticket_id, TextBetween(MapSubString('Keywords', Upper(Remark&'-'&Failure_Detail)), '$', '~') as Keyword_Data
FROM F_TICKET

Upvotes: 1

Views: 466

Answers (1)

Hubert Dudek
Hubert Dudek

Reputation: 1732

You mapping load is including '$' and '~':

'$' &Todo& '~'

but TextBetween will not include them. It will just select text between them, excluding '$' and '~'.

So for sure you need to remove '$' and '~' from mapping load:

Keywords:
Mapping load 
    Upper(Keyword) as Keyword, 
    Todo
FROM 
    [$(ROOTPATH)\Config\projects\$(vPROJECTNAME)\Ticket_Defect_Keyword.xlsx]
    (ooxml, embedded labels, table is Sheet1);

load 
    ticket_id, 
    TextBetween(
        MapSubString('Keywords', Upper(Remark&'-'&Failure_Detail))
    , '$', '~') as Keyword_Data
FROM 
    F_TICKET

Upvotes: 2

Related Questions