topic Re: Applymap one to many in QlikView

Applymap one to many

vvvvvvizard — Sun, 31 Dec 2017 05:08:36 GMT

"Whenever there is a one to many relationship between tables then a separate table must be loaded into the data model instead of using a mapping table and applymap."

Ive read the existing threads and tested using an example and the above statement doesnt make sense.

As long as the mapping function values are distinct the other table can have duplicate values, they will be correctly mapped. So a 1 to many relationship does work. It wont work on many to many relationship or on a one to many only if the mapping function values are the many. As long as the mapping function values are distinct the function will work correctly.

Eg maptable:

Load * in line [

One

Two

Three

] ;

If the table being mapped to has many 1, 1, 1, it will still work, so one to many works just depends on which table is the many, the maptable cant be the many.

Correct me if im wrong

Re: Applymap one to many

pradosh_thakur — Sun, 31 Dec 2017 06:58:42 GMT

Hi Yusuf

The way I VIEW it one to many in mapping table doesn't make SENSE.

Anyways coming back to your question

Applymap should be used when there is one to one relationship in the mapping table or else apply map will only pick the first matching record. You can create duplicate record though by using some other functions like subfield,concat etc but that wont make much SENSE.

here is some link for you to go through.

https://community.qlik.com/thread/147241?_ga=2.107238274.1456937817.1514696311-1643433312.1498286902

https://community.qlik.com/docs/DOC-17760

Re: Applymap one to many

avinashelite — Mon, 01 Jan 2018 09:51:06 GMT

if I understood properly ..you have a mapping table with distinct value s i.e. 1:1 relation and if your fact/calling table has 1:M then your totally rite here