topic Match fields and add to table in QlikView

Match fields and add to table

gerhardl — Wed, 11 May 2011 07:34:20 GMT

Hi,

If I am loading from two separate tables and they have one matching field, how do I add a new field to the second table using data from the first?

So:

Table 1 - Field A and B

Table 2 - Field A

I need to add Field B to Table 2.

Example:

Table 1:

Table 2:

Thanks,

Wed, 11 May 2011 07:40:05 GMT

try this

table2:

load

field_A

from ...

table1:

left join

load

field_A

field_B

from...

where exits(field_A)

Wed, 11 May 2011 08:24:37 GMT

Please see attached file.

It's working in this case.