Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: denormaliser and variable column names

  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Default denormaliser and variable column names

    Hi,

    I am trying to turn 1 column into several columns, as would be done in the Row denormliser step. However, I do not want to type in all of the column names for the new columns. I have a second original column that holds the name of the new column where the value of that row should be stored in.

    For example:

    Name:  denormaliser.JPG
Views: 251
Size:  17.4 KB

    Any suggestions would be greatly appreciated.

    Thanks,
    Julie
    Last edited by jmedalie; 07-05-2011 at 02:38 PM.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

  3. #3
    Join Date
    Sep 2010
    Posts
    14

    Default

    Hi gutlez,

    Thanks for the reply. This is exactly what I am looking for. Hopefully I will get this to work.

    Thanks,
    Julie

  4. #4

    Default

    Hello,

    I tried following the solution from Matt in that blog, but i'm missing something..

    The only differenceis i'm creating in a repository, and i get an error like this.. Any help would be greatlya ppreciated ! Thankyou..

    2013/01/15 14:26:43 - ETL Metadata Injection.0 - Running on slave server #0/1.
    2013/01/15 14:26:43 - fetch_Branch_Names.0 - Running on slave server #0/1.
    2013/01/15 14:26:43 - attr_value.0 - Running on slave server #0/1.
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Bad encoding!
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : java.lang.NullPointerException
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.metainject.MetaInject.init(MetaInject.java:307)
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62)
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2013/01/15 14:26:43 - ETL Metadata Injection.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error initializing step [ETL Metadata Injection]
    2013/01/15 14:26:43 - fetch_Branch_Names.0 - Connected to database...
    2013/01/15 14:26:43 - Inject - Step [Denormalizer fields.0] initialized flawlessly.
    2013/01/15 14:26:43 - Inject - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Step [ETL Metadata Injection.0] failed to initialize!
    2013/01/15 14:26:43 - Inject - Step [fetch_Branch_Names.0] initialized flawlessly.
    2013/01/15 14:26:43 - Inject - Step [attr_value.0] initialized flawlessly.
    2013/01/15 14:26:43 - fetch_Branch_Names.0 - Finished reading query, closing connection.

    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:821)
    at org.pentaho.di.ui.spoon.trans.TransGraph.debug(TransGraph.java:3451)
    at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:920)
    at org.pentaho.di.ui.spoon.Spoon$32$1.run(Spoon.java:7538)
    at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1183)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6966)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:567)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

  5. #5

    Default

    The exact same template worked if I chose option 1of the transformation template in the ETL Metadata injection step
    i.e. "Use a file for the transformation template" This requires me to save my ktr file on to my local machine, and cannot be the repository.

    The other two options (repository and reference) fail.

    Why is that ? I really need to be using from the repository.

    Any ideas ?

    Thanks !

  6. #6
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi Sue.
    Maybe you can test it and if it's a bug file it using Jira:
    http://jira.pentaho.com/secure/Dashboard.jspa

    Mick

  7. #7
    Join Date
    Nov 1999
    Posts
    459

    Default

    FYI: http://jira.pentaho.com/browse/PDI-9152

    Thanks for the bug report!
    Jens

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.