Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
wenyan1206
Luminary Alumni
Luminary Alumni

Imperfect Data Connection

Hey guys!

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?

Thank you

EX)

rapture_20190118113048.jpg

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

wenyan1206
Luminary Alumni
Luminary Alumni
Author

Thank you for your great solution and suggestion.
I'll try them.