title: Return all rows after Aggregator - Informatica Powercenter
body: <p>IMAGE  - </p>
  
  <p><img src="https://i.stack.imgur.com/Bo7GL.png" alt="Input, Scenarios and expected output"></p>
  
  <p>Please refer to the image for better understanding of the scenarios
  - For input from table I have 5 columns COL1,COL2,COL3,COL4,COL5
  - Scenario 1, 2, 3, 4 explains the types of input I will receive. The Value in Col 4 can vary(for example 31-35 or 36-39 for same value in Col1)
  -The column SUM is summation of values for all numbers in VALUE column of each scenario, and that has to be populated in all the rows. Like 50 in each cell for Scenario 1 under Column (SUM)</p>
  
  <p>The requirement -
  Summation to get the Value ex- 50 and then display all the rows (3-20) + Column G in the out put table
  So input table has 17 rows 5 Columns(B,C,D,E,F) Output should have 17 rows 6 columns(B,C,D,E,F,G)</p>
  
  <p>I could do the summation by grouping and using aggregate transformation in Informatica but I cannot display all the rows as grouping returns one row.</p>