Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Row Denomarlization

  1. #1

    Default Row Denomarlization

    I've read 2 or 3 posts about denormalizing. One of them asks for a dynamic solution without having to know the name of denormalized columns beforehand. One of the answers states that that would be pointless. But what about my simple case? How to resolve it easily?

    I have:

    Variable | Value
    ----------+-------
    myparam | myvalue1
    myparam2| myvalue2
    (...)


    and I simply need to denormalize it to:

    myparam | myparam2 | (...)
    ---------+-----------+---
    myvalue1 | myvalue2 | (...)

    just to input it to a Set Env Vars Step, which needs the info distirbuted field by field

    Would you help me? Thanks!

    P.S: Is there any way to use set Vars dynamically as well? I don't want to know what are the pairs to set beforehand
    Last edited by bizintreader; 05-21-2014 at 10:46 AM.

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

    Default

    Why would you do that?

    Just feed your perfectly normalized key/value pairs to a JavaScript step containing

    Code:
    setVariable(Variable, Value, "r");
    So long, and thanks for all the fish.

  3. #3

    Default

    Nice 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.