Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Replace value with null

  1. #1

    Default Replace value with null

    Can anyone tell me how to replace "" with null values.
    I have used if field value is null . But im getting '''''''''' instead of "".Then I have used javascript as value='""'. Here also im getting same issue.

    Help me.

  2. #2
    Join Date
    Apr 2008


    Which step get your input data?
    Are you reading a text file? Or a DB?
    Are you going to save the file as text or to upload it to another db?
    Version of PDI used?
    -- Mick --

  3. #3


    I have a inut csv file. and one column is assigned as empty. But in Output csv file I have to get double quotes for all fields and values and delimiter is |.
    If I use If field value is null in intermediate step,im getting """"""instead of "" because of force the enclosure around fields.


  4. #4


    I have created Generate Data Instead of CSV as Input. Can you check. I will Attach KTR file as well
    Attached Files Attached Files

  5. #5


    No im getting null Only. Don't know how to handle without javascript.

  6. #6


    Can you please specify what is the desired outcome?
    Right now, the CSV file has output the following:
    "not empty"|"full 2"
    |"full 1"

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.