Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Row De-normalizer - "Concatenate strings separated by ," not working

  1. #1
    Join Date
    Apr 2007
    Posts
    7

    Default Row De-normalizer - "Concatenate strings separated by ," not working

    Hi all,

    I've been trying to concatenate multiple entries for the same key value in a grouping with the "Concatenate strings separated by ," aggregation selected in the De-Normalizer step. All I get is the last value to pass through the step. When I select "Number of Values" aggregation I get the correct result which leads me to believe that I have the step defined correctly.

    Here is a sample of what I'm after:

    Input

    PK KEY KEY_VALUE
    1 column_name col1
    1 column_name col2
    1 column_name col2


    Output

    PK COLUMNS
    1 col1,col2,col3

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    just tried the denormalizer step, and it did not work for me neither... You should probably file a JIRA case regarding this.
    I see another option that might help you along, though. The "group by" step can concatenate individual values too. See attached sample.

    Cheers

    Slawo
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2007
    Posts
    7

    Default

    Thank you Slawo. I've opened a JIRA case as well http://jira.pentaho.com/browse/PDI-4524

    I'll check out the Group By step you mentioned.

    Thanks again.

  4. #4
    Join Date
    Apr 2007
    Posts
    7

    Default

    "Group By" step worked perfectly! Thank you!

  5. #5

    Default

    Guys I implemented the missing functionality in row denormaliser to "Concatenate strings separated by ,"

    http://jira.pentaho.com/browse/PDI-4524
    Tony, Cloud2Land.com

    Get the latest snapshot Pentaho Data Integration (Kettle) builds from SVN on my blog!
    http://www.cloud2land.com/

  6. #6
    Join Date
    Sep 2009
    Posts
    810

    Default

    Cool, thx

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.