Topic
2 replies Latest Post - ‏2012-09-02T12:26:41Z by SystemAdmin
SystemAdmin
SystemAdmin
7754 Posts
ACCEPTED ANSWER

Pinned topic Char aggregate?

‏2012-08-31T21:19:32Z |
Hi,
I'm new to DS.
Which DS process would be the best to bring File 1 to File 2 shown below?

File 1
A B C D
1 3
1 5
1 7

File 2
A B C D
1 3 5 7
Updated on 2012-09-02T12:26:41Z at 2012-09-02T12:26:41Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    7754 Posts
    ACCEPTED ANSWER

    Re: Char aggregate?

    ‏2012-08-31T21:24:38Z  in response to SystemAdmin
    INput file is

    1 | A | | |
    1 | | B | |
    1 | | | C |

    output file should be

    1 | A | B | C |
    • SystemAdmin
      SystemAdmin
      7754 Posts
      ACCEPTED ANSWER

      Re: Char aggregate?

      ‏2012-09-02T12:26:41Z  in response to SystemAdmin
      Hi Seza-

      I am not pretty sure if you using parallel or server jobs ...i will assume it is parallel jobs
      And i am assuming your input/ouput file is something like that

      Input:
      Col_01|Col_02|Col_03|Col_04
      1 | A | |
      1 | | B |
      1 | | | C

      Ouput:

      Col_01|Col_02|Col_03|Col_04
      1 | A | B | C

      I recommend using the Aggregator stage
      Group By: Col_01
      Aggregation Type: Calculation

      Column for Calculation: Col_02
      * Maximum Value Output Column
      Column for Calculation: Col_03
      * Maximum Value Output Column
      Column for Calculation: Col_02
      * Maximum Value Output Column
      Column for Calculation: Col_04
      * Maximum Value Output Column
      If you need any further info please let me know

      Kind regards,
      Karim Khalifa
      http://www.linkedin.com/in/karimkhalifa