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.
    Ramya

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

    Default

    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

    Default

    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.


    Ramya

  4. #4

    Default

    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

    Default

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

  6. #6

    Default

    Ramya,
    Can you please specify what is the desired outcome?
    Right now, the CSV file has output the following:
    Code:
    "empty_field"|"full_field"
    "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.