Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Problem with the Row denormaliser / source file without key field

  1. #1
    Join Date
    Dec 2007
    Posts
    24

    Default Problem with the Row denormaliser / source file without key field

    Hello,
    I have a problem with the Row denormaliser.
    I have a file which includes nobody key field.

    Here an example of the data

    Field01; Field02
    0815; 12 x
    0815; 13 x
    0816; 12 x
    9816; 80 x
    9816; 81 x
    9816; 82 x

    purpose should be to be illustrated the data so

    Field01,Field02_01;Field02_02;Field02_03
    0815; 12 x; 13 x
    0816; 12 x
    9816; 80 x; 81 x; 82 x

    Like I am able to do the data denormalisieren?

    OR

    How I can provide a counter (key field) for every unequivocal value of the Feld01 (group change)

    Regards
    Ingo

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Hallo Ingo,

    This nasty problem has come up before on the forum.

    A per-group counter can be added with the "Group by" step, if you use the "Include all" option.

    Matt

  3. #3
    Join Date
    Dec 2007
    Posts
    24

    Default

    Hello Matt,

    Really!!!!!

    it is this - thanks

    Ingo

  4. #4
    Join Date
    Jan 2009
    Posts
    12

    Default transforming variable rows of data per key to one

    hello,
    I was reading this thread, and the problem that ingo baden presented is the same that I'm trying to deal with today. But I cant' figure out how to accomplish the task from what was said in the thread and the various Spoon tools and I'm hoping someone here could give me some clearcut steps to take to accomplish a solution to the problem.
    I'm trying to turn an Excel file input that has two columns w/ a header row where the number of carrier entries per the key column accountnumber are variable:

    accountnumber carrier
    123 abc
    123 def
    456 ghi
    789 jkl
    789 mno
    789 pqr
    012 stu
    345 vwx
    345 yza

    into this where each unique account number has the collection of carrier data on the same row

    accountnumber carrier collection
    123 abc def
    456 ghi
    789 jkl mno pqr
    012 stu
    345 vwx yza

    Thanks in advance for anyone's assitance with a solution to this!
    david

  5. #5
    Join Date
    May 2006
    Posts
    4,882

    Default

    Don't double post ... No-one will answer your post faster if you post it 3 or more times

    Regards,
    Sven

  6. #6
    Join Date
    Jan 2009
    Posts
    12

    Default

    sorry 'bout that.
    thanks,
    david

  7. #7

    Post Probably more elegant solution...

    Dear all,

    I guess for this purpose you don't even have to use the De-Normaliser and the workaround with the per-group-counter (I hope I understood that right).

    Just use only the "Group by" step applying the really helpful text-aggregation method (concatentation), as you see it in the attached screenshots:

    Group field: Field01 (the "key")
    Subject: Field02 (the "text")
    Type: Concatenate strings with separator
    Value: the separator - e.g. ";"

    Regards,
    Andreas



    Quote Originally Posted by MattCasters View Post
    Hallo Ingo,

    This nasty problem has come up before on the forum.

    A per-group counter can be added with the "Group by" step, if you use the "Include all" option.

    Matt
    Attached Images Attached Images   

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.