

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Many to Many relationship Mapping???
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why not just load this table into your app?
Need more details to help properly


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Firstly, here is a question: When 2EP02 assumes 2EP02 and when does it assume 2QRAD?
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried to do that. It created circular loops in the data model.
