topic Re: Many to Many relationship Mapping??? in QlikView

Many to Many relationship Mapping???

poluvidyasagar — Sat, 16 Nov 2024 05:10:14 GMT

Hi,

I am currently facing an issue with mapping a table with applymap. Unfortunately, my mapping has many to many relation ship and I can not figure out a way to do this.

Example data:

UsepointMHA	System MHA
2EM01	2EM00
2EM02	2EM00
2EM03	2EM00
2EM04	2EM00
2EP01	2EP01
2EP02	2EP02
2EP03	2EP03
2EM02	2QMTR
2EP02	2QRAD

I have multiple values for 2EP02 if I map UsePointMHA to SystemMHA and Similarly if i want to SystemMHA to UsePointMHA, 2EM00 have multiple values. This is only sample data, i have lot of cases similar to this.

Is there anyway for me to map this table so that when i try to map usepointmHA , i get all the values of SystemMHA and vice versa.

I am currently using Apply Map function for mapping or vlookup.

Thanks,

Vidya
Vidya

Re: Many to Many relationship Mapping???

dplr-rn — Wed, 21 Nov 2018 21:08:47 GMT

I don't think you Can do this using applymap.
Why not just load this table into your app?
Need more details to help properly

Re: Many to Many relationship Mapping???

Thiago_Justen_ — Wed, 21 Nov 2018 21:36:15 GMT

Firstly, here is a question: When 2EP02 assumes 2EP02 and when does it assume 2QRAD?

Re: Many to Many relationship Mapping???

jonathandienst — Thu, 22 Nov 2018 06:11:28 GMT

Mapping is not the solution in this case. Depending on your data model, you could let Qlik handle the associations, or you could create a link table.

Re: Many to Many relationship Mapping???

poluvidyasagar — Mon, 26 Nov 2018 14:09:03 GMT

Hi,

I am adding more data to make it more clear:

Here are my tables:

Table1: ProductionSytemData

Part	Location	UsePointMHA
A	2EM01AA	2EM01
A	2EP02EE	2EM02
B	2EM01AA	2EM01
C	2EM01AA	2EM01
D	2EM02AA	2EM01
D	2EM02AB	2EM01
E	2EM03AA	2EM01
F	2EM04AA	2EM01
G	2EP01BB	2EP01
H	2EP02BB	2EP02
I	2EP02CC	2EP02
J	2EP03DD	2EP03
J	2EP03DD	2EP03
L	2EP02EE	2EP02
H	2EP02BB	2EP02

Table2: Logistics SystemData

Part	SystemLocation	SystemMHA
A	2E12345	2EM00
B	2E12346	2EM00
C	2E12347	2EM00
D	2E12348	2EM00
D	2E12360	2EM00
E	2E12349	2EM00
F	2E12350	2EM00
G	2E12351	2EP01
H	2E12352	2EP02
I	2E12353	2EP02
J	2E12354	2EP03
J	2E12355	2EP03
L	2E12356	2QRAD
A	2E12357	2QMTR
H	2E12358	2QRAD

Table 3: Mapping Table

UsepointMHA	System MHA
2EM01	2EM00
2EM02	2EM00
2EM03	2EM00
2EM04	2EM00
2EP01	2EP01
2EP02	2EP02
2EP03	2EP03
2EM02	2QMTR
2EP02	2QRAD

Results table: This is what i need. Because I have many to many relationship i am not able to achieve this.

Part	SystemMHA	#UsePoints	#SystemUsePoints
A	2EM00	1	1
A	2QMTR	1	1
B	2EM00	1	1
C	2EM00	1	1
D	2EM00	2	2
E	2EM00	1	1
F	2EM00	1	1
G	2EP01	1	1
H	2EP02	1	1
I	2EP02	1	1
J	2EP03	2	2
L	2QRAD	1	1

I have attached the Qlikview file.

Thanks,

Vidya

Re: Many to Many relationship Mapping???

poluvidyasagar — Tue, 27 Nov 2018 18:56:25 GMT

I tried to do that. It created circular loops in the data model.