2 Replies Latest reply: Jul 4, 2013 5:28 AM by Mohit Sharma RSS

    Use NoConcatenate (), still create $syn1 table...

      The following two table is not the same, i try to use keywords NoConcatenate, however, the result is not my expectation. Moreover, a $syn1 table has been created. Or if i have the case as below,  i need to use QUALIFY *  to solve it??

       

      [Table_A]:

      LOAD * INLINE [

          Field1, Field2, Field3

          A, B, C

          A, B, C

          A, B, C

      ];

       

      [Table_B]:

      NoConcatenate

      LOAD * INLINE [

          Field1, Field2, Field3

          D, D, D

          E, E, E

          F, F, F

      ];

       

      Any syntax error? Pls advise