Not applicable
2016-10-21
03:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wildmapping data model
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
358 Views
1 Reply
marcus_sommer
MVP
2016-10-21
03:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take a look here: Re: One to many match using wildmatch.
- Marcus
328 Views