Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel not null rows transformation

  1. #1
    Join Date
    Mar 2016
    Posts
    3

    Default Excel not null rows transformation

    Hi everyone

    I am trying to load data from Excel input table to Postgres table output. In input table I have 2 rows with text values that can be null (empty)in first row, and numeric not null values in second row. In output table I need 2 rows with not null values from input table. In SQL it will be:
    Select *
    from Input table
    Where row_1 is not null.

    How can I get this using Kettle transofrmation? It will be helpfull if this problem can solve by SQL statement in Kettle transformation.

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

    Default

    You could use a Filter Rows step.
    -- Mick --

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.