I'd like to connect "Date 01" and "Master Date", but "Data 01" is not so perfect like following.
①Name includes Capital letter small letter.
②Keywords like 'orange' is set in Name irregularly
Is there any way to give a key to "Data 01" to connect with Master Data?
Download and play with the Qlik Sense version of the sample here:
Qlikview Cookbook: Indexing Keywords in Text http://qlikviewcookbook.com/recipes/download-info/indexing-keywords-in-text/
You may have to add a replace(Name,'-', ' ') to the example script to change the - to a space.
View solution in original post