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

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

jblomqvist — Wed, 20 May 2015 10:44:08 GMT

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?

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

petter — Wed, 20 May 2015 10:47:33 GMT

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.

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

petter — Wed, 20 May 2015 10:48:51 GMT

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

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

Wed, 20 May 2015 10:51:51 GMT

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

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

awhitfield — Wed, 20 May 2015 10:58:48 GMT

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