topic Re: matching data on multiple text string in QlikView

matching data on multiple text string

Fri, 20 Nov 2020 18:02:30 GMT

Hi there, i've a question not sure how to solve.

imagine this load:

ID ALIAS

01 AAA

02 BBB

03 CCC

and this other load

DATE TEXT

in the field text i can have this kind of text (there is no standard on the input of this text field:

Please mark AAA as done

BBB was uploaded.

Request CCC to shutdown

I'm trying based on the column ALIAS to select all it's matchings on TEXT field. and not really sure it's possible.

Thanks in advance!

Re: matching data on multiple text string

maxgro — Wed, 25 Mar 2015 21:18:57 GMT

maybe a button?

Re: matching data on multiple text string

Gabriel — Wed, 25 Mar 2015 21:30:30 GMT

Hi,

My suggestion is to cleanse the field Text field from script and associate the field with ALIAS. As this.

Data:

LOAD * Inline

[

ID,ALIAS

01, AAA

02 ,BBB

03 ,CCC

];

Data_Text:

LOAD

KeepChar(Text,'AAABBBCCCDDD') AS ALIAS, // You can expand on the AABBCC to include any combination that //might possibly be in ALIAS field. This help with performance in the UI.

Inline [

Text

Please mark AAA as done

BBB was uploaded.

Request CCC to shutdown

];

You just need 2 list boxes in the UI 1 for ALIAS & 2nd for Text.

Hope this helps

Re: matching data on multiple text string

rwunderlich — Wed, 25 Mar 2015 22:36:31 GMT

Assuming ALIAS are whole words, you can create linkage between ALIAS and Text using this example:

Qlikview Cookbook: Indexing Keywords in Text http://qlikviewcookbook.com/recipes/download-info/indexing-keywords-in-text/

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: matching data on multiple text string

Mon, 30 Mar 2015 14:23:53 GMT

Hey there i've changed quite a bit the example to adapt it to my sources, like...

Keywords:

LOAD

mapsubstring('ChrMap', ALIAS) as ALIAS

FROM

(ooxml, embedded labels, table is file_source);

Reviews:

LOAD upper(mapsubstring('ChrMap', Description)) as Description, RecNo() as DescriptionId

Inner Join(Keywords)

// Inner Join -- only Keywords that have a matching Review will be kept. Change to "Left Join" to keep all keywords.

LOAD

	DescriptionId,
	subfield(PurgeChar(Description, '[]",.!?_'), ' ') as ALIAS
	//subfield(Description, ' ') as ALIAS

RESIDENT Reviews

It seems to work but just for random description items

i search for for example A4S ALIAS, and some ones does the match and others don't

I can search in the Description column 9 items matching A4S and using this procedure just finds 5 no clue what can happen

any help?

thx!