Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Dynamic Table Output

  1. #1

    Default Dynamic Table Output

    Hi all,

    Once again I return to this wonderful fountain of wisdom to gain more knowledge about this BI tool.

    I've found myself in quite a problem. I have a job that ends in a Table Output to a User Dimension on my Data Mart.

    However, the fields that are inserted in this User Dimension are dynamically generated in a transformation previous to this job.

    How can I do this table output with some of its fields dynamically generated?

    Thanks in advance,

    --jr, Portugal
    Last edited by joaoromao; 01-27-2011 at 11:14 AM.

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    You don't need to specify the column names in the Table Output.
    If you use the same name names in your transformation columns as they are used in the table, you should be fine.

  3. #3

    Default

    I don't understand. If I don't specify the column names, nothing gets loaded to the datamart. I tried not to specify them, and I got no error. But when I visualized the database I only had the Auto Incremented mysql generated column.

    Edit: And the destiny table is empty. Because I don't know how many variable columns I have, neither the max amount of them.

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Perhaps the rows being offered to the "Table Output" step were empty then.
    If it were really completely dynamic you could also try a "Select Values" step in a templated transformation together with the metadata injection step (PDI >= 4.1.0)

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.