Model association through a wild match

[Anonymous]

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

[marcus_sommer · Accepted solution]

Have a look here: Data Cleansing

- Marcus

[Peter_Cammaert]

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

[Anonymous]

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

[Anonymous]

Many thanks Peter