Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Merging Blank Column Data

  1. #1
    Join Date
    Apr 2008
    Posts
    123

    Default Merging Blank Column Data

    What is the best transformation to use to do this:


    Code:
    A  B  C  D  E  F
             1  2  3
    4  5  6
    7  8  9
    
    
    Convert this to:
    
    A    B    C
    1    2    3
    4    5    6
    7    8    9
    Thanks
    Last edited by roco; 11-06-2008 at 06:08 PM.

  2. #2

    Default Calculator or Modified JavaScript Values

    Either the Calculator or Modified JavaScript Values steps should work.

    Chris
    BreadboardBI.com

  3. #3
    Join Date
    Apr 2008
    Posts
    123

    Default

    Thanks for your quick reply. Would you mind elaborating a little?

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

    Default

    Both steps have an NVL(A,B) function. "If A is null then return B else A".

  5. #5

    Default

    If you use a table input step I suggest to let your SQL server do the job: COALESCE(A, D) or a similar function...

    Regards,
    Christoph
    21 is only half the truth

  6. #6
    Join Date
    Apr 2008
    Posts
    123

    Default

    Thanks - This is great help! I have had some success with the Calculator, and will try the SQL statement as well.

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.