Left keep not working as expected

[danielrogra]

Hello all. First of all thank you for your time.

I'm sure there is something I'm missing, but left keep is not working as I expected. Let me explain:

Let's say I have two tables:

Table A:

Name	Year	Month
A	2018	1
B	2018	2

Table B:

Name	Amount	Product
A	1	87
C	2	90
A	3	50

What I need? I need to load the first Table and then load the second table only when the name is on the table A.

What have I done? I've loaded the whole table A. Then I use left keep as follow:

Table B:

Left Keep(Table A)

Load *;Select * from TableB;

So I got two tables, but it seems that the user A appears just once on the table B. If I use Left Join it works perfectly but I need to understand why left keep is not working, and also I prefer to have two tables instead of only one with all the information.

Is there anyone who can help me?

Thank you in advance

Daniel

EDIT:

I've found the solution, but I don't understand where was the issue...

I forgot to mention that I had another table (With dates) between tables A and B, and I was using just "left keep". Now I've added "left keep (Table A) and it's working as expected...Does it make sense?

Thank you!

[danielrogra]

That was the problem, I guess. Thank you!

The second table (Date tables) share with the first one just date_id. And the last one share just with thw first one the name