1 Reply Latest reply: Oct 21, 2016 3:47 PM by Marcus Sommer RSS

    Wildmapping data model

    Xinzhen Wang

      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