Wildmapping data model

[#1]

Hello I have a data model question -

I have an event table with event counts and dim1 and dim2 and a mapping table with mapping of dim1 and dim2 into other string value as follows:

EventTable:

dim1

dim2*

eventcnt

Mapping table:

group

website

dim1

dim2

(group, website) has a one-to-many mapping with dim1.

(group, website) has a one-to-many mapping with dim2

dim2* and dim2 has  many-to-one wild matching mapping. (like "abcd", "abce" match to "abc*")

What is your suggest to build this data model in Qlik Sense?

Thanks,

Xinzhen

[marcus_sommer]

Take a look here: Re: One to many match using wildmatch‌.

- Marcus