13 Replies Latest reply: Apr 21, 2014 8:44 AM by Casper Casper RSS

    How to get similar outcome?

      Hi guys,

       

      hope you can help. I have this script:

      T1:

      LOAD * Inline [

      F1, F2

      a, 1

      a, 2

      b, 3

      c, 4

      ];

       

      T2:

      LOAD DISTINCT * Inline [

      F1, F2

      a, 1

      b, 3

      b, 3

      c, 4

      ];

       

      I need to have this result:

      F1     F2

      a        1

      a        2

      b        3

      c        4

      a        1

      c        4

      b        3

       

      It should only have one table in the data model with the content as shown above. Data should not be change in the two sources only the Load script.

       

      hope someone can help. thanks.