Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How can I create a new column to a business table

  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Default How can I create a new column to a business table

    Hi,
    I'm trying to create a new column and add it to a business table using the Metadata Editor, the column is supposed to contain the value of two columns from the business table

    example:
    business table: Tab 1
    tab 1: column a, column b,
    I would like to a create a column c where (column c: value column a + value column b)

    can anyone give me a hint on how to do that...
    I've been looking since this morning in the forum and the examples that comes with the installation but failed to find what I'm looking for
    Last edited by samdann; 07-15-2008 at 12:37 PM.

  2. #2
    Join Date
    Jul 2008
    Posts
    5

    Default

    anyone to help pleaaaaaaaaaase!!!

  3. #3
    Join Date
    Jan 2008
    Posts
    4

    Default Metadata Formulas

    Hi,

    Create new the column on the PHYSICAL table on the PME (not the business table) and then add it on the business table.

    Follow the link http://wiki.pentaho.com/display/Pent...adata+Formulas for Formulas explanation.

    Luis

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.