How do I bring in one field from a table to another table when there is no direct link?

[jblomqvist]

Hello,

I am trying to bring in Rate values from Table B into Table A however I am not sure how to do it as there is no direct link between the tables.

I thought about doing a Mapping Load but this doesn't work.

There is a link table in between as the diagram below shows but I am not sure if this helps.

Does anyone know how to do this?

[petter]

That is the beauty and simplicity of QlikView and Qlik Sense. The associative database will traverse the necessary tables to match up the values from various tables correctly.

For this reason you have to make sure that your data model is correct and that the keys are correct.

[petter]

You don't have to bring Rate values from table B to table A in order to use them together.

[#4]

Hi,

As per diagram above, I can see that there is indirect link between Table A and Table B. if yes, you can follow below step

1. Get Key from the link table to table A.

2. Once Key field is there in Table A you can do the mapping between A and B.

Regards

Nandkishor Pandirkar

[awhitfield · Accepted solution]

That's exactly how Qlikview works!, see the very simple attachment;

Script:

TableA:
Load * Inline
[
Field
A
];
LinkTable:
Load * Inline
[
Field, Key
A, 1
];
TableB:
Load * Inline
[
Key, Rate
1, 100
];

Table viewer

Result

HTH Andy