Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
maybe a button?
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
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
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!