Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Dynamic Combine

  1. #1
    Join Date
    Mar 2013
    Posts
    148

    Default Dynamic Combine

    Hi,

    I want to combine string value based on other value dynamically. If any yes flag is coming repetitively then it has to consider last 'N' Value so that it will combine my expected result.

    Can anyone help into this

    My source file looks like

    id flag value
    1 N A
    2 N B
    3 Y C
    4 Y D
    5 N E
    6 N F
    7 Y G
    8 N H
















    My Target file has to look like

    id flag value
    1 N A
    2 N BCD
    5 N E
    6 N FG
    7 N H
    Attached Files Attached Files
    Last edited by pentaho2013; 01-20-2017 at 10:44 AM. Reason: datagrid

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Thanks for the grid.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    148

    Default

    Quote Originally Posted by marabu View Post
    Thanks for the grid.
    Thanks Marabu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.