2 Replies Latest reply: Oct 6, 2016 7:15 AM by Sunny Talwar RSS

    Generic Prefix (Join)

    scotly victor

      Hi Everyone,

      As we know the generic prefix will generate three table .

      However is it possible to join three table  into one single table by key.

      I have given example

       

      Table1:

      Generic LOAD * INLINE;

      [

      Key, Attribute, Value

      Bob, Jan, 100

      Bob, Feb, 200

      Bob, Mar, 300

      Kate, Jan, 400

      Kate, Feb, 500

      Kate, Mar, 600

      ];

      Result:

      This will result in 3 tables:

      Table1.Jan:

      Key,Jan
      Bob,100
      Kate,400

      Table1.Feb:

      Key,Feb
      Bob,200
      Kate,500

      Table1.Mar:

      Key,Mar
      Bob,300
      Kate,600