Load of two tables

[#1]

Good day,

My friends, I am with a big trouble here and i'm not able to figure out how to solve.

First I connect a table file, ex. table A with fields a, b, c.

Then I connect another table, table B, with fields d, e, f.

I change one field of the second table B to create a conection with the Table A, field a.

But what is happening is that all the values in Table B are being considered and it's not being considered the values in Table A that are not in Table B.

Example

Table A	Table B	Considered
1	1	1
2	3	3
3	5	5
4	6	6
5	7	7
6

I want that Qlikview consider all information, i mean Table A information plus Table B information.

But table A and table B can't be joined.

Hope this is clearly.

Tks,

[jvitantonio · Accepted solution]

TABLEA:

LOAD  fieldA, fieldB from table1;

TABLEB:

LEFT KEEP (TABLEA)

LOAD fieldC as fieldA, fieldD, fieldF from table2;