Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: denorm

  1. #1
    Join Date
    Mar 2013
    Posts
    148

    Default denorm

    Hi,

    I am attaching my input scenario of how the data looks like and i am expecting two output results .

    Output 1:

    ident name1 name2 name3 str
    ABC DEF GHI:YZ JKL:AY MNO PQR STU VWX 15:30:45
    KY 123 JKL:A DXY ZYX MNO 25:30







    Output 2:

    ident name1_JKL
    ABC AY
    KY A
    Attached Files Attached Files

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

    Default

    It's easy to solve this by using a pattern shown in your other thread.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    148

    Default

    Quote Originally Posted by marabu View Post
    It's easy to solve this by using a pattern shown in your other thread.
    I don't think previous pattern will solve my whole problem.. How can we combine and denormalize and search the specific string and get the results like output 1 and output 2

    Can u help me on this

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

    Default

    Concatenation is done with Group-By.
    Transposition is done with Row-Denormaliser.
    You'll need Split-Field and Split-Field-To-Rows, too.

    And last not least you'll need the "Repeat-Groupfield"-Pattern (I just coined that) twice:

    1. User-Defined-Java-Expression to identify a group change by setting a marker to 1 instead of 0.
    2. Group-By to convert a sequence of marker into a series of group-ids.


    Should be easy now.

  5. #5
    Join Date
    Mar 2013
    Posts
    148

    Default

    Thanks for your help.

    I have a doubt instead of parsing and splitting entire file i want final output as which is mentioned in output 2. I have two files data which is shown in earlier data grid instead of doing parsing and denorm doing entire files i want to search for the particular string and get the value i.e

    ident name1_jkl
    ABC AY
    KY A

    Is there any possibility to avoid all the below scenarios

    Quote Originally Posted by marabu View Post
    Concatenation is done with Group-By.
    Transposition is done with Row-Denormaliser.
    You'll need Split-Field and Split-Field-To-Rows, too.

    And last not least you'll need the "Repeat-Groupfield"-Pattern (I just coined that) twice:

    1. User-Defined-Java-Expression to identify a group change by setting a marker to 1 instead of 0.
    2. Group-By to convert a sequence of marker into a series of group-ids.


    Should be easy now.

  6. #6
    Join Date
    Mar 2013
    Posts
    148

    Default

    Quote Originally Posted by pentaho2013 View Post
    Thanks for your help.

    I have a doubt instead of parsing and splitting entire file i want final output as which is mentioned in output 2. I have two files data which is shown in earlier data grid instead of doing parsing and denorm doing entire files i want to search for the particular string and get the value i.e

    ident name1_jkl
    ABC AY
    KY A

    Is there any possibility to avoid all the below scenarios
    Attached with partial ktr. I tried only append not able to get what has to be done.

    Any help which i am looking for the below outputs

    output 1:

    ident name name name str
    ABC DEF GHI:YZ JKL: AY MNO PAR STU VWX 15:30:45
    KY 123 JKL:A DXY ZYX MNO 25:30





    output2:
    ident name_JKL
    ABC AY
    KY A
    Attached Files Attached Files

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.