1 Reply Latest reply on Dec 2, 2019 9:53 AM by Nico Heinze

    Power Center Grouping Scenario

    Abhidha P Seasoned Veteran

      Hi ,

      I have below data and want to get the output as given below , please help.

        

      Source Data

       

      CUST_IDGROUP_ID
      1011
      1021
      1031
      1042
      1052
      1062
      1072
      1083
      1093
      1103
      1113
      1124
      1134
      1145
      1155

       

      Output required

       

         

      CUST_IDGROUP_IDOUTPUT
      1011101|102|103
      1021101|102|103
      1031101|102|103
      1042104|105|106|107
      1052104|105|106|107
      1062104|105|106|107
      1072104|105|106|107
      1083108|109|110|111
      1093108|109|110|111
      1103108|109|110|111
      1113108|109|110|111
      1124112|113
      1134112|113
      1145114|115
      1155114|115
        • 1. Re: Power Center Grouping Scenario
          Nico Heinze Guru

          Sort the data by group ID followed by customer ID.

           

          Denormalize those records per group ID (using an AGG, for example) to get the combined strings like "114|115". This way you get one record per group ID.

           

          Re-sort these data by customer ID and join this data stream using a Joiner transformation with the original source data (sorted by customer ID so that you can use a Joiner with Sorted Input).

           

          Regards,

          Nico