topic Re: Model association through a wild match in QlikView

Model association through a wild match

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following QV model:

The FDADMFs table is linked to the PharmaMarketWorld table via the field DMFSubject. In some cases, the DMFSubject can be spelt in a different way in the two tables. For example it might appear as 'ARIPIPRAZOLE' in one table and 'ARIPIPRAZOLE USP' in another table. This obviously means the two will be treated as different fields and not be associated. Is there a way to associate these and treat them as similar through a wild match?

Regards.

Chris

Re: Model association through a wild match

marcus_sommer — Tue, 15 Mar 2016 15:12:36 GMT

Have a look here: Data Cleansing

- Marcus

Re: Model association through a wild match

Peter_Cammaert — Tue, 15 Mar 2016 15:17:15 GMT

No, QlikView associations are exact matches, case-sensitive if you use strings as key fields.

As Marcus already indicated, you have to prepare your data (using translations or mapping tables) before loading it into your data model.

Peter

Re: Model association through a wild match

Anonymous — Tue, 15 Mar 2016 16:23:56 GMT

Many thanks Marcus, i can also do the cleaning in SQL server integration services below loading it into my datawarehouse

Re: Model association through a wild match

Anonymous — Tue, 15 Mar 2016 16:24:30 GMT

Many thanks Peter