topic Re: Imperfect Data Connection in Connectivity & Data Prep

Imperfect Data Connection

wenyan1206 — Fri, 18 Jan 2019 02:56:19 GMT

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 — Fri, 18 Jan 2019 03:38:13 GMT

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 — Fri, 18 Jan 2019 08:26:37 GMT

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