Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Howto use De-normalize?

  1. #1

    Default Howto use De-normalize?

    Hello, I'm new on ETL tools and i have a small problem.

    I have this table:

    Nombre ApellidoPat ApellidoMat Status NombrePercepDeduc Monto
    Pancho Perez Perez A SUELDO 1.00
    Pancho Perez Perez A IMSS 2.00
    Pancho Perez Perez A ISR 3.00
    Juanito Perez Perez A SUELDO 1.00
    Juanito Perez Perez A IMSS 2.00
    Juanito Perez Perez A ISR 3.00

    And i need to be like this

    Nombre ApellidoPat ApellidoMat Status SUELDO IMSS ISR
    Pancho Perez Perez A 1.00 2.00 3.00
    Juanito Perez Perez A 1.00 2.00 3.00

    According the wiki on De-normalize tables, i have to use the NombrePercepDeduc as key, then the ID of our workers on grouping and repeat on target fields the data from NombrePercepDeduc with every value (SUELDO, IMSS, etc).

    But I get error at preview, I think my settings on this are incorrect.

    Can you help me to understand this?

    I'm using Kettle 4.4.0 Stable

    Thanks!!
    Attached Images Attached Images  

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

    Default

    With your sample data the denormaliser should look slightly different ...
    Attached Images Attached Images  
    So long, and thanks for all the fish.

  3. #3

    Default

    Thank you marabu, with your example works fine. My mistake was using NombrePercepDeduc on target fields and need to be the Monto field.

    Thanks.

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.