10 Replies Latest reply: May 5, 2018 9:51 AM by Daniel Rodríguez RSS

    Left keep not working as expected

    Daniel Rodríguez

      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:

      NameYearMonth
      A20181
      B20182

       

      Table B:

      Name

      AmountProduct
      A187
      C290
      A350

       

      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!