Solved: Re: Imperfect Data Connection - Qlik Community

wenyan1206 · ‎2019-01-17

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)

rwunderlich · ‎2019-01-17

Download and play with the Qlik Sense version of the sample here:

You may have to add a replace(Name,'-', ' ') to the example script to change the - to a space.

rwunderlich · ‎2019-01-17

Download and play with the Qlik Sense version of the sample here:

You may have to add a replace(Name,'-', ' ') to the example script to change the - to a space.

wenyan1206 · ‎2019-01-18

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