5 Replies Latest reply: Apr 28, 2017 9:24 AM by Денис Петров RSS

    Left keep - than to replace?

    Денис Петров

      Hello dear colleagues! Faced the problem - when using the LEFT KEEP I lost the record, I decided to replace the LEFT KEEP on OUTER JOIN, but there was another problem - an error that the following table could not be found. What else can you replace the LEFT KEEP except for an OUTER JOIN?

       

      Tab_1:

      left keep(TABLE_2)  "I Replace left keep on outer join in this line"

      LOAD

          fld_1,  

          fld_2,

          fld_3,

          fld_4,

          fld_5

      FROM [$(vPathLoadEvents)]

      (qvd);

       

      Dict:

      left keep(TABLE_3)

      LOAD

          fld_1,

          fld_2

      FROM [D:\01_Dictionary\Dict.qvd]

      (qvd);