4 Replies Latest reply: Feb 2, 2017 9:00 AM by omkar pechetti RSS

    Concatenate and distinct

    Mindaugas Bacius

      Hei,

       

      I've faced an interesting issue.

      While making Concetanate I am also using Distinct of the table I do concatenate.

      Unfortunately, after that all the values have become Distinct in whole table.


      There is an example.

      Without Distinct:

      TMP:

      LOAD * INLINE [

          F1

          1

          2

          1

      ];

       

      Concatenate(TMP)

      LOAD * INLINE [

          F1

          3

          3

          4

      ];

      Screenshot_2.jpg

       

      With Distinct:

      TMP:

      LOAD * INLINE [

          F1

          1

          2

          1

      ];

       

      Concatenate(TMP)

      LOAD Distinct * INLINE [

          F1

          3

          3

          4

      ];

      Screenshot_3.jpg

       

      I would like to understand the fundamentals of this issue. Why is that so?

      Thank you!