Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: EAV using Normaliser

  1. #1
    Join Date
    Nov 2016
    Posts
    1

    Default EAV using Normaliser

    I am trying to change data that is in typical row format to Entity Attribute Value format using the Row Normaliser.


    My source data is as follows:


    My Normaliser is setup as follows:


    And here are the results:

    Why is the value for the CONDITION_START_DATE and CONDITION_STOP_DATE in the string_value column instead of the date_value column?
    According to this documentation

    • Fieldname: Name of the fields to normalize
    • Type: Give a string to classify the field.
    • New field: You can give one or more fields where the new value should transferred to.

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

    Default

    With each type (attribute) occuring only once only the first new field will be filled.
    Attached Files Attached Files
    Last edited by marabu; 11-25-2016 at 02:06 PM. Reason: demo attached
    So long, and thanks for all the fish.

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.